delete from和delete * from 的区别

来源：学生作业帮编辑：作业帮分类：综合作业时间：2024/05/10 12:47:33

delete from和delete * from 的区别
小弟在编程时遇到了一个问题,工具是vb6.0,数据库是SQL2000,想实现删除用户表里面选中用户ID的全部信息,在语句sql="delete * from 用户表 where 用户名='"& combo1.text &"'"时提示*附近有语法错误,在去掉*时测运行成功,这是为什么呢

delete * from - 没有这种语法,只有delete from
更快速不能回滚的删除：
TRUNCATE TABLE table_name;

delete from和delete * from 的区别 delete from与delete * from delete from tablea & truncate table tablea 的区别? Delete和Erase的区别 operator delete与delete的区别是什么? I have delete you from my delete table from table where …… DELETE FROM L_DanWei WHERE dw_id = @dw_id just delete me from your buddy list SQL简单语句 DELETE FROM table delete,remove的区别是什么在VC中delete[]与delete的真正区别