sql
豆腐饭请
这个作者很懒,什么都没留下…
展开
-
sql01
修改自己表里面重复的数据,只保留一条create table temp as select id as c from machine_score where model in ( select model from machine_score GROUP BY model HAVING count(*) > 1 ) and id not in (select min(i原创 2017-11-28 15:31:40 · 186 阅读 · 0 评论 -
数据库通过文件导入数据
从文件中导入规则的数据到表 load data local infile ‘d:/aa.txt’ into table machine_score(name, model, score, type);原创 2017-11-25 15:50:25 · 245 阅读 · 0 评论