CREATE TABLE student( -- 创建学生表,并传入列和列的类型(字符串要引号)
id INT,
NAME VARCHAR(20),
chinese FLOAT,
english FLOAT,
math FLOAT
);
4.对应列输入对应的值
INSERT INTO student VALUES(1,'张小明',89,78,90);-- 对应列输入对应的值
INSERT INTO student VALUES(2,'李进',67,53,95);
INSERT INTO student VALUES(3,'王五',87,78,77);
INSERT INTO student VALUES(4,'李一',88,98,92);
INSERT INTO student VALUES(5,'李来财',82,84,67);
INSERT INTO student VALUES(6,'张进宝',55,85,45);
INSERT INTO student VALUES(7,'黄蓉',75,65,30);