1.字符串拼接
select distinct concat(concat(name,'-'),age) as msg from student where name like '李%' order by name asc,age desc;
2.gbase 查表名
show tables where tables_in_zxvmax like '%test%';
1.字符串拼接
select distinct concat(concat(name,'-'),age) as msg from student where name like '李%' order by name asc,age desc;
2.gbase 查表名
show tables where tables_in_zxvmax like '%test%';
转载于:https://www.cnblogs.com/yongwangzhiqian/p/5691548.html