多表更新
多表更新通过UPDATE语句实现,其语法是:
UPDATE TABLE_references
SET col_name1 = { expr1 | DEFAULT } [ , … ]
[WHERE WHERE_cONditiON]
多表删除
多表删除通过DELETE语句实现,其语法为:
DELETE tbl_name[.*] [ , tbl_name[.*] ] ...
FROM TABLE_references
[ WHERE WHERE_cONditiON ]
2022-12-02 22:29:29
多表更新通过UPDATE语句实现,其语法是:
UPDATE TABLE_references
SET col_name1 = { expr1 | DEFAULT } [ , … ]
[WHERE WHERE_cONditiON]
多表删除通过DELETE语句实现,其语法为:
DELETE tbl_name[.*] [ , tbl_name[.*] ] ...
FROM TABLE_references
[ WHERE WHERE_cONditiON ]