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

This article mainly introduces in detail the method of printing data to a file in MySQL. The sample code in this article is very detailed and has a certain reference value. Interested friends can refer to it.

Create alias

Alias db='mysql-hlocalhost-uroot-p123456'

Create the execution file for the mysql statement: mysql.txt

Select * from test_db.test_table

Enter on the Linux command line

$db

Store.log

The data in the final store.log is the result of select * from db.table.

It works so well!

The above is a brief introduction to the method of printing data to a file in MySQL. Of course, the differences in the detailed use of the above have to be understood by everyone. If you want to know more, 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.