这很可能是因为您至少命名了一个约束，且其标识符与列相同：
ConSTRAINT `restaurant` FOREIGN KEY (`restaurant` ) REFERENCES `mydb`.`restaurants` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION)
应该为约束使用其他标识符，例如
fk_restaurant：
ConSTRAINT `fk_restaurant` FOREIGN KEY (`restaurant` ) REFERENCES `mydb`.`restaurants` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION)
和
food表中的相同：
ConSTRAINT `fk_food` FOREIGN KEY (`food` ) REFERENCES `mydb`.`food` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION, ConSTRAINT `fk_restaurant` FOREIGN KEY (`restaurant` ) REFERENCES `mydb`.`restaurants` (`id` ) ON DELETE NO ACTION ON UPDATE NO ACTION)
这些是我看到的仅有的三个，但可能还有其他我想念的。
