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.

Where is the mysql database stored?

869

---

What is append query?

861

---

What are enums used for in mysql?

948

---

What can I do with mysql?

858

---

What storage engines are used in MySQL?

982

---

How do I setup mysql?

853

---

What is key in mysql?

834

---

What are the functions used to encrypt and decrypt the data present in mysql?

1010

---

Why do we use mysql?

879

---

What are the critical issues you have resolved in your company

2169

---

What is unsigned int in mysql?

870

---

What are date and time intervals?

922

---

Is mariadb faster than mysql?

903

---

Why do we use preparedstatement?

851

---

How to store values to array from mysql database in php?

874

---