--建库CREATE DATABASE chapter03;--使用数据库USE chapter03;--建表CREATE TABLE student( id INT(4), name VARCHAR(20) NOT NULL, grade FLOAT);--插入数据INSERT INTO student(id,name,grade)VALUES(1,'zhangsan',98.5);--更新数据UPDATE student SET grade=grade+10;UPDATE student SET grade=100 where grade>100;