mysql - MySQL outfile 生成的带有行起始字符串的文件

Question

如何使用特定字符串开始由 MySQL outfile 生成的文件？

我当前正在使用以下查询:

SELECT * FROM rmssettings
INTO OUTFILE 'F:\\Assignment\\VIEWS1.sql'
FIELDS TERMINATED BY ',' LINES STARTING BY 'Insert' OPTIONALLY ENCLOSED BY '"'
LINES TERMINATED BY '\r\n';

Answer 1

您想要开始的字符串是什么样的？

你可以这样做:

SELECT "foo, bar, baz, hello\n", rmssettings.* FROM rmssettings
INTO OUTFILE 'F:\\Assignment\\VIEWS1.sql'
...