【文件属性】：
文件名称：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'