Shulou(Shulou.com)05/31 Report--

This article mainly explains "how MySQL5.7 uses SELECT... INTO statement to export data files". Interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Let's let the editor take you to learn how MySQL5.7 uses SELECT... INTO statements to export data files.

Use SELECT... INTO statements can import query results into variables or files

SELECT... INTO var_list stores the query results in variables.

SELECT... INTO OUTFILE writes the query results to a file. You need to specify delimiters for fields and rows to generate output files in a specific format.

SELECT... INTO DUMPFILE writes a single line to an unformatted file and exports only one line of file, which can be used to handle large fields such as TEXT, BLOB, and so on.

SELECT... INTO OUTFILE example:

Mysql > select * from test into outfile'/ tmp/test_out.txt' fields terminated by', 'optionally enclosed by''

Query OK, 4 rows affected (0.01sec)

-- View the contents of the exported file

[root@localhost tmp] # cat test_out.txt

"0," RESEARCH "," DALLAS "

"0," SALES "," CHICAGO "

"0," OPERATIONS "," BOSTON "

"0," MAINTENANCE "," HULUDAO "

SELECT... INTO DUMPFILE example:

Mysql > select * from test where deptno=20 into dumpfile'/ tmp/test_20_dump.txt'

Query OK, 1 row affected (0.00 sec)

[root@localhost tmp] # cat test_20_dump.txt

-- View the contents of the exported file

[root@localhost tmp] # vim test_20_dump.txt

20RESEARCHDALLAS ^ M

At this point, I believe you have a deeper understanding of "how MySQL5.7 uses SELECT... INTO statements to export data files". You might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!

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.