3.2w+
社区成员
- 主页
- 基础类
- 应用实例
- 新技术前沿
...全文
请发表友善的回复…
发表回复
happydreamer 2003-01-03
1）删掉重复的：
alter table 表 add newfield int identity(1,1)
delete 表
where newfield not in(
select min(newfield) from 表 group by 除newfield外的所有字段
)
alter table 表 drop column newfield
2）
DELETE L
FROM table L
JOIN table R
ON L.字段1 = R.字段1 AND L.id > R.id
alter table 表 add newfield int identity(1,1)
delete 表
where newfield not in(
select min(newfield) from 表 group by 除newfield外的所有字段
)
alter table 表 drop column newfield
2）
DELETE L
FROM table L
JOIN table R
ON L.字段1 = R.字段1 AND L.id > R.id
mymmsc 2003-01-03
delete * from tablename where 主键 = (那条全为0的记录主键）
CrazyFor 2003-01-03
delect * from tablename where
col1=0 and col2=0 and col3=0 and .....
col1=0 and col2=0 and col3=0 and .....
愉快的登山者 2003-01-03
delete * from tablename where 主键 = (那条全为0的记录主键）