| M | Field is too long, can it be displayed on multiple lines

雕像五代

Ok my sql
string sql;
sql = "SELECT * FROM (SELECT MAX (id) AS id, type FROM merchandise GROUP BY type) f INNER JOIN (SELECT c.id, a.main, b.kind, c.name, c.type, c.present , c.image FROM main a INNER JOIN merchandise c ON a.id = c.main INNER JOIN kind b ON c.kind = b.id) e ON f.id = e.id ORDER BY f.id DESC "

I don't want to use
sql = "*********"
sql + = "*******" this way
Is there sql = "****************
            ****************
            ****************"this way

shenmue024

sql = @ "
a
b
bs
b
c
bz
b
 ";

shenmue024

Just add @ in front.

aol365

StringBuilder strSql = new StringBuilder ();
strSql.Append ("insert into tb_s_user (");
strSql.Append ("ID, LoginName, Password, UserName, UserSign)");
strSql.Append ("values ​​(");
strSql.Append ("@ ID, @ LoginName, @ Password, @ UserName, @ UserSign)");

strSql.ToString ()