sql语句
瑶光喵
这个作者很懒,什么都没留下…
展开
-
MySQL查询属性值
记一个小知识检索一张表的字段属性和注释SELECT COLUMN_NAME, COLUMN_COMMENT FROM information_schema.`COLUMNS` WHERE TABLE_SCHEMA = 'db_name' AND TABLE_NAME = 'table_name'检索所有信息SELECT *FROM information_schem...原创 2020-01-04 09:52:36 · 442 阅读 · 0 评论 -
sql记录去重
转载自https://blog.csdn.net/longshenlmj/article/details/17528265自己纪录一下1、查找表中多余的重复记录,重复记录是根据单个字段(peopleId)来判断select*from peoplewhere peopleIdin (select peopleIdfrom peoplegroupby peopleIdhaving count(...转载 2019-07-19 09:20:43 · 459 阅读 · 0 评论 -
如何导出MySQL索引的创建语句
转载自SELECT CONCAT( 'ALTER TABLE',TABLE_NAME ,‘', 'ADD ', IF ( NON_UNIQUE = 1, CASE UPPER( INDEX_TYPE ) WHEN 'FULLTEXT' THEN 'FULLTEXT INDEX' WHEN 'SPATIAL' THEN 'SPATIAL INDEX' ELSE CONCAT...转载 2019-10-10 17:28:01 · 430 阅读 · 0 评论