SQL学习

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%';