mysql数据库新增记录

INSERT INTO users (username, email, password)
VALUES ('john_doe', 'john@example.com', 'secure_password');

INSERT INTO users (username, email, password)
VALUES 
('jane_doe', 'jane@example.com', 'another_password'),
('alice', 'alice@example.com', 'yet_another_password');

INSERT INTO old_users (username, email)
SELECT username, email FROM users WHERE active = 0;

INSERT IGNORE INTO users (id, username, email)
VALUES (1, 'existing_user', 'user@example.com');

-- 错误的示例
INSERT INTO products (name, price)
VALUES ('Laptop', '1000'); -- price 应该是数值类型

-- 正确的示例
INSERT INTO products (name, price)
VALUES ('Laptop', 1000);

ALTER TABLE users CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

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