创建 和 添加表格

创建

CREATE TABLE score(
sid INT,
sname VARCHAR(10),
js DOUBLE,
css DOUBLE,
html DOUBLE
)

删除drop table score

添加

INSERT INTO score VALUES(1,'tom',88,66,40);
INSERT INTO score VALUES(1,'jerry',54,90,100);
INSERT INTO score VALUES(1,'tony',77,90,66);
INSERT INTO score VALUES(1,'amy',88,76,80);

查看SELECT * FROM score