Articles under the label of SQL

  1.  Home
  2. SQL

SQL 两列字段，合并为一个字符串，中间加符号

数值型：select cast(a as varchar(10))+','+cast(b as varchar(10)) from tablename 字符型：select a+','+b from tablename 字符型：varchar select a+','+b from tablename char select rtrim(a)+','+rtrim(b) from tablen...

 LEN   March 10, 2017  No comments

Mysql SQL判断数据库是否存在及查看数据库列表

SELECT 1 `status` FROM information_schema.SCHEMATA ...

 LEN   March 9, 2017  No comments