delete from * where name = "" 有什么错

[game4cn]

delete from * where name = "" 有什么错

[anglely168]

没有表名字啊！

[llzczf]

delete tablename1 where name = "" 有什么错

[hobo_man]

不明

[leeyoong]

delete tablename1 where name = "" 有什么错
这句话没错！

[smartdonkey]

同意飞刀

[marvellin]

oracle中：
delete from table_name where nvl(name,'')='';

[wanghai]

delete 表名 where 条件

[helpeachother]

delete 表名 where name = ''

[michaelzhang]

delete from * where name = "" ----没有这样用的吧，
delete from tablename where ...

[ge_san_tu]

重新学习一遍语法吧!!!

[kks]

试试：
delete from (select table_name from tabs) where name is null

[veryeasy]

delete tablename1 where name = '' or name is null

[kks]

错了！错了！应该这样：
declare
cursor gettablename is select table_name from tabs;
temp varchar2(30);
begin
open gettablename;
loop;
fetch gettablename into temp;
exit when gettablename%notfound;
begin
execute immediate 'delete from '||temp||' where name is null;
exception
when others then
null;
end;
end loop;
end;

[feidao1]

这样：delete 表名 where name = ''

[phwind]

好象*不能用在这里.你想,如果用*,那么没有Name字段的表就会出错!!!

[chgo]

直接清空数据库不就行了吗

[tjm1]

delete * from tablename

[park_lang]

sybase中
DELETE * FROM TABLE WHERE COLLUM IS NULL

[park_lang]

不好意思，上面*不需要 而且FROM也可以省略

[yaoxiaofeng]

要完成什么样的操作？