Oracle
SELECT string || column_name || ... FROM table_name; -- 将一个字符串与列值进行拼接
MySql
SELECT CONCAT(string, column,...) FROM table_name;
SELECT string || column_name || ... FROM table_name; -- 将一个字符串与列值进行拼接
SELECT CONCAT(string, column,...) FROM table_name;
本文标题：拼接字符串
本文链接：https://www.haomeiwen.com/subject/ctoodxtx.html
网友评论