- 查询当前数据库下所有表名称(包括视图)以及备注描述
SELECT table_name AS 'name', table_comment AS 'comment' FROM information_schema.TABLES WHERE table_schema = (SELECT DATABASE ());
- 查询指定表#{tableName}中所有字段以及字段描述
SELECT DISTINCT COLUMN_NAME AS 'field',COLUMN_COMMENT AS 'description' FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name =
SELECT
DATE_SUB( curdate( ), INTERVAL - 1 DAY ) day1 UNION
SELECT
DATE_SUB( curdate( ), INTERVAL - 2 DAY ) day2 UNION
SELECT
DATE_SUB( curdate( ), INTERVAL - 3 DAY ) day3 UNION
SELECT
DATE_SUB( curdate( ), INTERVAL - 4 DAY ) day4 UNION
SELECT
DATE_SUB( curdate( ), INTERVAL - 5 DAY ) day5 UNION
SELECT
DATE_SUB( curdate( ), INTERVAL - 6 DAY ) day6 UNION
SELECT
DATE_SUB( curdate( ), INTERVAL - 7 DAY ) day7;
group_concat([DISTINCT] 要连接的字段 [Order BY ASC/DESC 排序字段] [Separator '分隔符'])
select id,group_concat(name) from db_name group by id
|1 | 10,20,20|
select id,group_concat(name separator ";") from db_name group by id
|1 | 10;20;20|
select id,group_concat(distinct name separator";") from db_name group by id
|1 | 10;20;20|
select id,group_concat(name order by name desc separator";") from db_name group by id
|1 | 20;20;10|