CREATE DATABASE test;
USE test;
-- 创建表，新增password字段用于存储MD5密码
CREATE TABLE student (
    id INT,
    english_name VARCHAR(255),
    password VARCHAR(255)
);

--插入数据
INSERT INTO student VALUES (1, 'Liu Yi', 'E10ADC3949BA59ABBE56E057F20F883E');
INSERT INTO student VALUES (2, 'Chen Er',  'AAA42296669B958C3CEE6C0475C8093E');
INSERT INTO student VALUES (3, 'Zhang San',  'F1BFD514F667CEBD7595218B5A40D5B1');
INSERT INTO student VALUES (4, 'Li Si',  '579D9EC9D0C3D687AAA91289AC2854E4');
INSERT INTO student VALUES (5, 'Wang Wu',  '8D421E892A47DFF539F46142EB09E56B');
INSERT INTO student VALUES (6, 'Zhao Liu',  'E363373DDC24B34C5BB9D99ABBFD8BE5');
INSERT INTO student VALUES (7, 'Sun Qi',  'EA48576F30BE1669971699C09AD05C94');
INSERT INTO student VALUES (8, 'Zhou Ba',  'B92FD8708E4E9228479AEDE2D689A2D0');
INSERT INTO student VALUES (9, 'Wu Jiu',  '86BD1DB79525ABDD576165C1427F9BF6');
INSERT INTO student VALUES (10, 'Zheng Shi',  'DD7DFAFFA6A31A0EE0E3E5C805F6342D');

-- 查询表数据
SELECT * FROM student;