56,679
社区成员
发帖
与我相关
我的任务
分享
INSERT INTO `sdb_orders` VALUES (20150819052127, 21613, 'N', 'active', '0', '0', 'null', 'Y', 11, '韵达', NULL, 30, 500.000, '纹瓜', 1, unix_timestamp(left(order_id, 10)),unix_timestamp(left(order_id, 10)), NULL, NULL, NULL, NULL, NULL, NULL, '115.235.245.21', '帅', '', '杨', '350011', '', NULL, '任意日期 任意时间段', '0', 1143.000, 'true', 'true', 0.000, '', 6.000, 'false', 0.000, 0.000, 'CNY', 1.0000, 0.000, 80.000, 1143.000, 0.000, 0.000, NULL, 1143.000, 1143.000, 0.000, 0.000, 0, 0.000, 'N', '', 0, NULL, 'false', unix_timestamp(left(order_id, 10)), 'false', 'b1', 'N;', 'false', 'local', NULL);
UPDATE `sdb_orders` SET `acttime`=
(unix_timestamp(str_to_date(`order_id` ,'%Y%m%d%H%i%s'))) ;
可以了,又犯了同样低级错误,谢谢兄弟了。。。UPDATE `sdb_orders` SET `acttime`=
(SELECT unix_timestamp(str_to_date(`order_id` ,'%Y%m%d%H%i%s')) FROM `sdb_orders`) ;
#1093 - You can't specify target table 'sdb_orders' for update in FROM clause
这是要另外建一个表,才能更新操作么?SELECT unix_timestamp((select str_to_date((SELECT `order_id` FROM `sdb_orders`),'%Y%m%d%H%i%s')));
1242 - Subquery returns more than 1 row
多行不能这样引用?