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 This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What could be the reason that the mysql statement 'select avg (salary) from emp' generates an inaccurate output?
How to enter Characters as HEX Numbers?
How does php communicate with mysql?
How many triggers are possible in mysql?
What are the differences between char and nchar?
Can you tell the difference between mysql_fetch_object and mysql_fetch_array?
Can we write pl sql mysql?
What is the use of mysqli_fetch_array?
How many columns can you create for an index?
Why do gaps in sequences occur?
What is the difference between the primary and unique key in mysql?
How do I stop a mysql service?
How to represent ENUMs and SETs internally?
What is bigint in mysql?
How does mysql store binary data?