t_book（从mysql下载查询结果的数据库表）

【文件属性】：

文件名称：t_book（从mysql下载查询结果的数据库表）

文件大小：1.56MB

文件格式：SQL

更新时间：2021-11-21 16:42:47

mysql

从mysql下载查询结果的数据库表,对应的sql为 SELECT * FROM t_book WHERE publishDate BETWEEN '2012-01-01' AND '2018-10-01' AND price BETWEEN 1000 AND 10000 AND bookName LIKE CONCAT('%','名','%') AND kind='言情' LIMIT 0,198 into outfile 'C:/ProgramData/MySQL/MySQL Server 5.7/Uploads/t_book.csv' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"' LINES TERMINATED BY '\r\n'