mysql 无法update

GRANT UPDATE ON database_name.table_name TO 'username'@'host';

UPDATE table_name SET column1 = value1 WHERE condition;

START TRANSACTION;
SELECT * FROM table_name WHERE condition FOR UPDATE;
UPDATE table_name SET column1 = value1 WHERE condition;
COMMIT;

mysql -h hostname -u username -p

ALTER TABLE table_name DROP FOREIGN KEY fk_name;
UPDATE table_name SET column1 = value1 WHERE condition;
ALTER TABLE table_name ADD FOREIGN KEY fk_name (column_name) REFERENCES other_table(column_name);

-- 简单更新
UPDATE users SET age = 30 WHERE id = 1;

-- 条件更新
UPDATE users SET age = age + 1 WHERE name = 'John';

-- 批量更新
UPDATE users SET age = 25 WHERE id IN (2, 3, 4);