There are scenarios like when changing a web server when you have to export data in file that can be imported in some other server. Here is an example to export data of a query in file from MySQL . SELECT * INTO OUTFILE 'filePath' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' FROM tablename; Where filepath is path of the file you want to export data to.
Technology GupShup is a place where you can articles on Software Development, Databases , Web Development and computers in general. You can also find useful tips and tutorials related to computers.