【Navicat 环境】MySQL 查询笔记

1.查询特定Keyword字段的所有列名

SELECT column_name FROM tablename.columns 
WHERE table_schema ='dbname'
AND table_name = 'tablename'
AND column_name like '%Delay%';

2.查询多个列名的合计数据

SELECT SUM(column1) Total1,SUM(column2) Total2,SUM(column3) Total3,
FROM tablename;

3.查询指定日期的特定列数据