DELETE 表格別名 FROM 表格名稱 AS 別名 WHERE 表格別名.欄位 = 值;

例：
DELETE u FROM user AS u WHERE u.id = 1;

例：
DELETE FROM user WHERE user.id = 2;



 















其它文章

arrow
arrow
    文章標籤
    db sql 用法 delete where from as mysql
    全站熱搜

    PG Levin Li 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄