无法使用正确的命令删除记录

DELETE FROM table_name WHERE condition;

DELETE FROM users WHERE id = 1;

SHOW GRANTS FOR 'username'@'host';

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

DELETE FROM orders WHERE user_id = 1;

DELETE FROM users WHERE id = 1;

mysql -u username -p

START TRANSACTION;
-- 执行一些操作
COMMIT; -- 或 ROLLBACK;
DELETE FROM users WHERE id = 1;

CREATE TABLE users (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    email VARCHAR(50)
);

INSERT INTO users (id, name, email) VALUES (1, 'Alice', 'alice@example.com');
INSERT INTO users (id, name, email) VALUES (2, 'Bob', 'bob@example.com');

DELETE FROM users WHERE id = 1;