MySQL 用户表创建语句 - SQL 代码示例

CREATE TABLE users ( id INT(11) NOT NULL AUTO_INCREMENT, username VARCHAR(50) NOT NULL, 'password' VARCHAR(255) NOT NULL, 'email' VARCHAR(255) NOT NULL, created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP, updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id), UNIQUE KEY username (username), UNIQUE KEY 'email' ('email') ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;