1,查询不重复字段总数
SELECT COUNT(*) FROM (SELECT DISTINCT station FROM stopname)AS a
2,将不重复值存入新表
INSERT INTO stopname_uni SELECT * FROM stopname GROUP BY station
3,日期格式化
SELECT id,`name` FROM user WHERE DATE_FORMAT(createtime,'%Y%m')>=201306
4,查询表字段,描述等表信息
SELECT * FROM information_schema.`COLUMNS`
WHERE TABLE_NAME='test';
SELECT COLUMN_NAME,COLUMN_COMMENT FROM information_schema.`COLUMNS`
WHERE TABLE_NAME='test';