mysql 指定插入列

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100),
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

INSERT INTO users (name, email, created_at)
VALUES ('Alice', 'alice@example.com', NOW());

INSERT INTO users (name, email)
VALUES ('Bob', 'bob@example.com');

-- 错误的列名
INSERT INTO users (nam, email)
VALUES ('Charlie', 'charlie@example.com');

-- 正确的列名
INSERT INTO users (name, email)
VALUES ('Charlie', 'charlie@example.com');

-- 错误的值类型
INSERT INTO users (name, email)
VALUES ('David', 12345);

-- 正确的值类型
INSERT INTO users (name, email)
VALUES ('David', 'david@example.com');