mysql 给字段默认值

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    status ENUM('active', 'disabled') DEFAULT 'active',
    views INT DEFAULT 0
);

-- 错误的默认值设置
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL,
    created_at TIMESTAMP DEFAULT '2023-10-01', -- 错误：类型不匹配
    status ENUM('active', 'disabled') DEFAULT 'active',
    views INT DEFAULT '0' -- 错误：类型不匹配
);

-- 正确的默认值设置
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    status ENUM('active', 'disabled') DEFAULT 'active',
    views INT DEFAULT 0
);