摘要:
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 @ 阅读全文
摘要:
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 阅读全文