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.

How do I select a table in mysql?

873

---

What is the difference between having and where clause in mysql? Explain

970

---

How do I find my mysql username and password?

933

---

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

871

---

How do you kill a long running query in mysql?

849

---

Write a query to stop mysql in unix

1009

---

What is 'mysqld'?

888

---

Can I use mariadb instead of mysql?

875

---

Which is faster innodb or myisam?

940

---

Can we join 3 tables in mysql?

915

---

How to get a version of mysql?

998

---

What are the advantages of MySQL when compared with Oracle?

894

---

What is the difference between mysql_connect and mysqli_connect?

920

---

What are the 3 main types of search queries?

790

---

How to do login in mysql with unix shell.

1048

---