MySQL Data sheet export data for Excel

The author recently due to the special needs of the company personnel, the MySQL database in the specific table exported to Excel format data saved. If you are bored, here are the steps:

1:cmd Open the database, mysql-uroot-p

2: Select the database, if you do not know the specific name; Type the command SHOW DATABASES; Switch to the target database, use DATABASENAME;

3: Select the table, if you do not know exactly which one, type the command show TABLES;

4: Output: SELECT * FROM tablename to outfile ' path ', path for you to prepare the output destination, the author of the e-packing directory is specifically written as SELECT * from the TableName into outfile ' E:/filename.xls ';

The MySQL specific data table is successfully exported to Excel format file

MySQL Data sheet export data for Excel