mysql往某一列插入数据

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50),
    email VARCHAR(100),
    age INT
);

INSERT INTO users (username) VALUES ('john_doe');

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

INSERT INTO users (username, age) VALUES ('alice', 30);

-- 错误示例
INSERT INTO users (useranme) VALUES ('john_doe');

-- 正确示例
INSERT INTO users (username) VALUES ('john_doe');

-- 错误示例
INSERT INTO users (username) VALUES ('john_doe'); -- 如果'john_doe'已经存在

-- 正确示例
INSERT INTO users (username) VALUES ('john_smith');

-- 批量插入示例
INSERT INTO users (username, email) VALUES 
('user1', 'user1@example.com'),
('user2', 'user2@example.com'),
('user3', 'user3@example.com');