sql示范:表名:course(课程)
INSERT INTO TABLE VALUE (value1,value2)
添加(Create):insert into course value("8","地理","1")
SELECT column1,column2 FROM table
查询(Retrieve): select cid,cname,tid from course
UPDATE table SET column1 = value1 WHERE 条件
更新(Update):update course set tid = 3 wher cname = "地理"
DELETE FROM table WHERE column1 = value1
删除(Delete):delete from course where cid = "8"
1.删除数据库表中的重复数据只保留一条数据
delete from table
where tableName in (select * from ((SELECT tableName from table group by tableName having count(tableName) > 1 )a))
and tableId not in (select * from ((select min(tableId) from table group by tableName having count(tableName) > 1)b))