摘要: use xfgs;SET SQL_SAFE_UPDATES = 0;SET @num = 0; update xfgs.news_t t set t.orderNum= (@num := @num + 1) 按排序后更新 use xfgs;SET SQL_SAFE_UPDATES = 0;SET @ 阅读全文
posted @ 2019-05-27 15:43 清枫林 阅读(779) 评论(0) 推荐(0) 编辑
摘要: MySql 执行 DELETE FROM Table 时,报 Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column 阅读全文
posted @ 2019-05-27 15:17 清枫林 阅读(427) 评论(0) 推荐(0) 编辑