Shulou(Shulou.com)06/01 Report--

Editor to share with you the method of exporting mysql data, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

MySQL is one of the most popular relational database management systems. In MySQL, we can use SELECT...INTO OUTFILE statements to simply export data to text files.

Use SELECT... INTO OUTFILE statement to export data

In the following example, we export the datasheet demo_tbl data to the / tmp/demo.txt file:

Mysql > SELECT * FROM demo_tbl-> INTO OUTFILE'/ tmp/demo.txt'

You can set the specified format of data output through the command options. The following example is the export CSV format:

Mysql > SELECT * FROM passwd INTO OUTFILE'/ tmp/demo.txt'-> FIELDS TERMINATED BY', 'ENCLOSED BY' "- > LINES TERMINATED BY'\ r\ n'

In the following example, a file is generated, with values separated by commas.

This format can be used by many programs.

SELECT aformab INTO OUTFILE'/ tmp/result.text'FIELDS TERMINATED BY', 'OPTIONALLY ENCLOSED BY' "'LINES TERMINATED BY'\ n'FROM test_table; above are all the contents of the method of exporting mysql data, thank you for reading! I believe you all have a certain understanding, hope to share the content is helpful to you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.