Answer Posted / nivedita

select INTO statement id used to take a back of the table.

syntax
select coloum_name(s) INTO NewTable(in external database)
from source table;
example: select * into person_backup from persons;

------------
another way is to take a dump
mysqldump -h hostname -u username -p password database >
backupdtabase.sql

o [username] - this is your database username
o [password] - this is the password for your database
o [databasename] - the name of your database
o [backupfile.sql] - the file to which the backup
should be written.

What is difference between schema and table?

916

---

How do I truncate all tables in mysql?

985

---

What is latest version of mysql?

1027

---

Can we write pl sql mysql?

947

---

how you will Create a database on the mysql server with unix shell.

1047

---

How do I disable mysql?

935

---

What is mysql url?

866

---

What is a trigger? How you can create a trigger in mysql?

899

---

how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.

906

---

How do I connect to a mysql database?

930

---

How can I change database in mysql?

888

---

What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?

916

---

What are the difference between mongodb and mysql?

1353

---

What is the difference between sql and mysql and oracle?

894

---

What is mysql root?

952

---