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.

Is mysql better than oracle?

986

---

What is the limit of mysql database?

998

---

What are the drivers in MySQL?

1534

---

What is the difference between float and double?

1185

---

Why mongodb is faster than mysql?

915

---

What is the use of concat() in mysql?

1044

---

How do I insert an image into mysql workbench?

1010

---

How many concurrent queries can mysql handle?

942

---

How do you determine the location of mysql data directory?

978

---

How do I download a mysql community server?

927

---

Is mysqli deprecated?

1015

---

What is a session in mysql?

1014

---

Is mysql server free?

976

---

What is the use of procedure in mysql?

975

---

Is mysql a relational database?

880

---