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
- 18225 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
Explain the ternary conditional operator in php?
What is the difference between laravel and php?
What is printf in php?
What is var_dump?
Tell me how to retrieve a cookie value?
What is stripslashes php?
What is rest api in php?
Which php mvc framework is best?
Do you know what does $globals means?
What is namespaces in PHP?
How do I stop a php script?
Does php support multiple inheritances?
Explain mysql_error().
What is curl php?
Which function can be used to delete a file?
