随笔分类 -  MYSQL

Mysql 删除重复数据
摘要：DELETE FROM 表名 WHERE id IN ( SELECT FROM ( SELECT id FROM 表名 WHERE (name_add,address) IN ( SELECT name_add,address FROM 表名 GROUP BY name_add,address H 阅读全文
posted @ 2019-12-10 09:54 Abduhelel 阅读(132) 评论(0) 推荐(0)
Mysql 查询重复数据
摘要：SELECT FROM 表名 WHERE (name_add,address) IN ( SELECT name_add,address FROM 表名 GROUP BY name_add,address HAVING COUNT(1) 1); 阅读全文
posted @ 2019-12-10 09:53 Abduhelel 阅读(228) 评论(0) 推荐(0)
Mysql 一个表中的规定字段导入另外一个表中的对应的字段
摘要：表2的数据导入表1 INSERT INTO 表1 (name_add, longitude, latitude, province, town, types, address, area, province_code, time_tamp, town_code, area_code, locatio 阅读全文
posted @ 2019-12-10 09:51 Abduhelel 阅读(751) 评论(0) 推荐(0)
Mysql 一个表中的 数据导入另外一个表
摘要：INSERT into 表1 SELECT from 表2 阅读全文
posted @ 2019-12-10 09:49 Abduhelel 阅读(287) 评论(0) 推荐(0)
Mysql 如何把一列的值全改成数值1或者0，
摘要：update 表名 set 列名 = 0 or 1 阅读全文
posted @ 2019-12-10 09:46 Abduhelel 阅读(2652) 评论(0) 推荐(0)