DELETE FROM TABLE_NAME 数据库删除行数据SQL
DELETE FROM TABLE_NAME1 WHERE ID=2.
DELETE FROM TABLE_NAME2. |DELETE * FROM TABLE_NAME2. 删除TABLE_NAME2表中所有列.
注:DELETE FROM 每删除一条会在事务日志中记录每行.若论删除效率TRUECATE效率要更高.
DELETE FROM TABLE_NAME1 WHERE ID=2.
DELETE FROM TABLE_NAME2. |DELETE * FROM TABLE_NAME2. 删除TABLE_NAME2表中所有列.
注:DELETE FROM 每删除一条会在事务日志中记录每行.若论删除效率TRUECATE效率要更高.