MySQL基本练习

CREATE DATABASE school;

USE school;
CREATE TABLE student(
id INT(4),
NAME VARCHAR(20) NOT NULL,
grade FLOAT
);

INSERT INTO student(id,NAME,grade)VALUES(1,”zhangsan”,98.5);
INSERT INTO student(NAME,grade,id)VALUES(“lisi”,32.1,2);
INSERT INTO student(id,NAME,grade)VALUES(3,”liangsheng”,10),(4,”sanming”,99),(5,”lujunlian”,100);

UPDATE student SET NAME=”pdd”,grade=”78” WHERE id=1;
UPDATE student SET NAME=”www”,grade=”98” WHERE id<4;

INSERT INTO student(id,NAME,grade)VALUES(6,”uu”,454);
UPDATE student SET NAME=”oo”,grade=23 WHERE id=6;
DELETE FROM student WHERE id=6;

CREATE TABLE student2(
id INT(3) PRIMARY KEY AUTO_INCREMENT,
NAME VARCHAR(20) NOT NULL,
grade FLOAT,
gender CHAR(2)
);

SELECT id,NAME,grade,gender FROM student2;
SELECT * FROM student2;
SELECT NAME FROM student2;

SELECT * FROM student2 WHERE id=1;
SELECT NAME,grade FROM student2 WHERE NAME=”zhangsan”;

SELECT * FROM student2 WHERE id IN (1,3,5);
SELECT NAME FROM student2 WHERE id NOT IN (1,3,5);

SELECT * FROM student2 WHERE id BETWEEN 1 AND 3;
SELECT NAME FROM student2 WHERE id BETWEEN 1 AND 3;