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.

using primary can we relate two table, with out foreign key?

2720

---

What is limit in mysql?

876

---

What is the data type for file in mysql?

993

---

How MySQL Optimizes DISTINCT?

1119

---

Is null in mysql?

876

---

What is procedure in mysql?

947

---

How many tables we can create in mysql database?

957

---

what is the procedure to configure the application of mysql?

1044

---

How to Join tables on common columns.

1196

---

What are the non-standard sql commands supported by 'mysql'?

1000

---

How to dump a table to a file with 'mysqldump'?

1040

---

Consider you have a composite index of three columns. Now, you have to provide the value of two columns in the where clause of a select query. Do you think index can be used for the operation?

1026

---

How do I enable mysqli extension?

1016

---

How to define numeric 9(3) in db2 table without decimal point??

2856

---

What is mysqli_free_result?

906

---