Want to every day around a table to specify the database field to Excel, but can not be imported into a Excel file, you will be prompted existing
The select baterry from bike into outfile 'C: bike. XLS';

CodePudding user response:

Don't support the
If you use SQL export Excel, use INTO OUTFILE that should be it, the export is a text file, the corresponding import can use the LOAD DATA

CodePudding user response:

Do not support the opendatasource, import can use the load data infile 'path into the table table name