UPDATE t_comment com SET com.create_time(SELECT finish_time FROM t_order o where o.order_idcom.order_id);
t_comment 表中相关索引 :
PRIMARY KEY (id),KEY ind_t_comment_orderid (order_id) USING BTREE
t_order 表中相关索引: …
常见的MySql的一个小错误,原本sql语句是没有出错的:让我们看看这个错误吧!
Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode, toggle the…