数据库删除重复属性列,错误[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 ·
987 阅读 ·
0 评论