mysql创建数据及设置默认值
mysql创建数据及设置默认值
CREATE TABLE douyin_user ( id INT PRIMARY KEY AUTO_INCREMENT, username VARCHAR(255) NOT NULL DEFAULT '', user_id VARCHAR(255) NOT NULL DEFAULT '', followers_count INT DEFAULT 0, following_count INT DEFAULT 0, likes_count INT DEFAULT 0, ip_location VARCHAR(255) DEFAULT '', verification_info VARCHAR(255) DEFAULT '', bio VARCHAR(255) DEFAULT '', age INT DEFAULT 0, province VARCHAR(255) DEFAULT '', city VARCHAR(255) DEFAULT '', avatar_url VARCHAR(255) DEFAULT '', qrcode_url VARCHAR(255) DEFAULT '', homepage_url VARCHAR(255) DEFAULT '', created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP );