Import data from Excel to MySQL and export data to excel

After a long period of practice, it seems that the simplest method is found:

1. Export MySQL to excel:

1.1.select * into OUTFILE '/test.xls' from Table1;

2. Import EXCEL to MySQL:

2. 1. Copy the selected data block to a TXT text file. If it is saved to the location "D: \ data.txt.
2. 2. create a MySQL database and table based on the data to be imported. The structure is consistent with the Excel structure. then, enter the command prompt and run the command load data local infile 'd: \ data.txt 'into table tablename fields terminated by '\ T ';
2. 3. Remove the carriage return symbol from the last column: Update tablename set lastcolumnname = Replace (lastcolumnname, '\ R ','');