mysql中deletefrom的作用？

delete from命令用于刪除表中的數據。delete from命令格式：delete from 表名 where

表達式如：

delete from sys_lamp where hcode ='111';

但是：

delete from sys_lamp l where l.hcode ='111'; 報錯

delete from 作用是刪除表內容，還保留表結構，通常結合where條件使用。