很是疑問,來看看共同進步
刪除語句 的語法 DELETE FROM TABLE WHERE 條件
那下面那個語句DELETE t1 FROM 用別名啥意思 ??語法沒錯???求詳解
DELETE t1 FROM tdb_goods AS t1 LEFT JOIN (SELECT ANY_VALUE(goods_id),goods_name FROM tdb_goods GROUP BY goods_name HAVING count(goods_name) >= 2 ) AS t2 ?ON t1.goods_name = t2.goods_name ?WHERE t1.goods_id > t2.goods_id;?
2016-07-27
你看視頻前面給的語法:DELETE tb1_name FROM table_references WHERE......
2016-07-27
SELECT出來的表算作第二個表（也就是括號里的），別名為t2,原來的表的別名為t1.還有什么疑問嗎？