数据库删除重复属性列,错误[HY000][1093] You can't specify target table 'orders' for update in FROM clause
存在一个orders表:CREATE TABLE `orders` (
`Id_o` int(11) NOT NULL AUTO_INCREMENT,
`orderNo` VARCHAR(20) NOT NULL,
`Id_p` int(11) DEFAULT NULL,
PRIMARY KEY (`Id_O`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8
原创
2017-07-13 11:11:46 ·
1001 阅读 ·
0 评论