SQL statement "link string" command in mysql

xiaoxiao2021-03-06  113

http://blog.yiz.name Connection strings often use " ", always let me sweat. . . It turns out that mysql is not like this. . . Concat (STR1, STR2, ...)

Returns a string from the parameter link. If any parameters are

NULL, return

NULL. It can have more than 2 parameters. A digital parameter is transformed into an equivalent string form.

MySQL> SELECT Concat ('my', 's', 'ql');

-> 'MySQL'

MySQL> SELECT Concat ('my', null, 'ql');

-> NULL

MySQL> SELECT Concat (14.3);

-> '14 .3 '

转载请注明原文地址:https://www.9cbs.com/read-100205.html

New Post(0)