Import data from excel to Mysql and export data to excel

After importing data from excel to Mysql and mysql to excel for so long, it seems that the simplest method is found: 1. mysql export to excel: 1.1.SELECT * into outfile '/test.xls' FROM table1; 2. import excel to mysql: www.2cto.com 2. 1. copy the selected data block to a TXT text file and save it to the location "D: \ data.txt. 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
Run the command load data local infile 'd: \ data.txt 'into table tablename fields terminated by '\ T'; 2. 3. remove the carriage return symbol of the last column: UPDATE tablename SET lastcolumnname =
REPLACE (lastcolumnname, '\ R ','');