班级网站源代码下载,深圳网站开发,南宁平台公司,做网站哪个靠谱需求
从mysql数据库中导出数据到excel
解决方案
sql导出csv文件
sql
SELECT col1,col2 FROM tab_01 WHERE col3 xxx
INTO OUTFILE /tmp/result.csv
FIELDS TERMINATED BY ,
ENCLOSED BY "
LINES TERMINATED BY \n;csv文件导出excel文件
1、【数据】-【导入数据】 …
需求
从mysql数据库中导出数据到excel
解决方案
sql导出csv文件
sql
SELECT col1,col2 FROM tab_01 WHERE col3 = 'xxx'
INTO OUTFILE '/tmp/result.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n';