With MySQL we can easily export our selected rows to the files. MySQL has several syntax which can export the retrieved rows into the file.
Yes we can import these rows back to database tables also.
Lets see how you can export rows to the file.
So after executing above query you can see the rows.txt on the server folder where database data files are stored.
Now import the exported files into database tables.
Note: FIELDS TERMINATED BY and LINES STARTING BY are used for the formatting purspose.
Avinash Zala is leading various projects which deals with the various technology involved with the web. A combination of perfect technical and management skills. Avinash would like to chat with you and convert your imagination into the working system. You can get in touch with him on Facebook and Twitter.
View all posts by: Avinash