MySQL删除数据Delete与Truncate语句使用比较

复制代码 代码如下:

TRUNCATE [TABLE] tbl_name

复制代码 代码如下:

truncate table friends;

复制代码 代码如下:

DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name

[WHERE where_definition]

[ORDER BY ...]

[LIMIT row_count]

复制代码 代码如下:

delete from friends where user_name = 'simaopig';delete