SQL学习

分类: IT文章 • 2022-04-26 10:31:36

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