计算机程序设计员三级考试第四题

CREATE DATABASE login_exam; USE login_exam; CREATE TABLE users ( id INT AUTO_INCREMENT PRIMARY KEY, username VARCHAR(20) NOT NULL UNIQUE, password VARCHAR(20) NOT NULL ); -- 插入测试数据 INSERT INTO users (username, password) VALUES ('zhangsan', 123456), ('lisi', '123456');