我想删除id = 142。1)user_master_activate 2)user_master表
使用union,其中两个表都有相同的列。DELETE FROM (SELECT * FROM user_master_activate UNION SELECT * FROM user_master ) AS U WHERE (U.id =
NULL ADD FOREIGN KEY (qid) EVERY 1 DAY DELETE FROM alternativ WHERE alternativ.qid IN (SELECT qidFROM question WHERE question.expired<CURRENT_TIMESTAMP)
DE
如果我有一个父表和一个子表,那么可以在没有"ON DELETE级联“约束的情况下多删除它们中的行吗?create table b(id int primary key, a_id int,为了删除表Cannot delete or update a parent row: a foreign key constraint fails
(`erasmusu6`.`b`, CONSTRAINT `fkb` F