Interested to Buy Any Domain ? << Click Here >> for more details...
How can we take a backup of a mysql table and how can we
restore it. ?
- 7 Answers
- 17692 Views
- Brain Infosys, Oracle, I also Faced
- E-Mail Answers
Answer Posted / ajay giri
We can use below query for exporting data to a .txt file.
mysql> SELECT * FROM <table_name> INTO
OUTFILE '<file_name>' FIELDS TERMINATED BY ',';
We can use below query for importing data from .txt file
mysql> LOAD DATA INFILE <file_name> INTO
TABLE '<table_name>'
FIELDS TERMINATED BY ',';
| Is This Answer Correct ? | 20 Yes | 4 No |
Post New Answer View All Answers
How to uploaded files to a table?
Is php is dying?
Write a statement to show the joining of multiple comparisons in php?
Which is not a php magic constant?
What is the difference between rest and soap?
What are Routines?
What is the difference between echo, print and printf()?
What is the difference between $argv and $argc? Give example?
Explain the syntax for ‘foreach’ loop with example.
Why php is widely used?
Difference between mysql_connect and mysql_pconnect?
Why is php so popular?
Is array function in php?
What is the difference between get and post in php?
What is array filter in php?
