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 free download?

847

---

What is the role of a limit in a mysql query?

1002

---

What ascii 31?

942

---

Do I need python for mysql?

923

---

Why do we use group by and order by function in mysql?

914

---

Restore database (or database table) from backup.

1020

---

Can you tell which of the following where clauses is faster?

900

---

What does do in mysql?

868

---

What is the use of i-am-a-dummy flag in mysql?

1005

---

How show all tables in mysql query?

916

---

Why is mysql popular?

863

---

What is the difference between procedure and function in mysql?

1014

---

Which mysql function is used to concatenate string?

1479

---

What are programming functions?

942

---

I want to find out all databases starting with ‘test’, I have access to?

1149

---