INSERT INTO mytable (myfield) VALUES (CONCAT_WS(CHAR(10 using utf8), ‘hi this is some text‘, ‘and this is a linefeed.‘, ‘and another‘));

这里CHAR(10)相当于换行符

www.it1352.com/1660375.html

MySQL 字符串拼接且换行