目录
删除性别为男的用户
DELETE FROM 用户表 WHERE 字段名=内容;
DELETE FROM users WHERE ugnder=’男’;
删除表中的所有数据
DELETE FROM users;
TRUNCATE语句删除数据
//改命令可以无条件删除表中的所有数据
TRUNCATER 数据表;
TRUNCATER users;
目录
DELETE FROM 用户表 WHERE 字段名=内容;
DELETE FROM users WHERE ugnder=’男’;
DELETE FROM users;
//改命令可以无条件删除表中的所有数据
TRUNCATER 数据表;
TRUNCATER users;