sql

标题java日记

Day 12
学习数据库Mysql


创建表
CREATE TABLE employee(
id INT,
NAME VARCHAR(20),
gender BOOL,
birthday DATE,
Entry_date DATE,
job VARCHAR(20),employee
Salary FLOAT,
RESUME TEXT
);
注意不要使用中文的标点符号，不然出现错误不容易查错

INSERT INTO employee(id,NAME,gender,birthday,Entry_date,job,Salary)
VALUES(2,‘123’,‘1’,‘2019-08-20’,‘2019-08-20’,‘总裁’,20000000);

UPDATE employee SET job='大佬’WHERE job=‘总裁’;

DELETE FROM employee WHERE NAME=123;

SELECT *FROM stu WHERE gender=‘女’ AND age>50
SELECT *FROM stu WHERE sid=1 OR sid=2 OR sid=3
SELECT *FROM stu WHERE sid IN(1,2,3)

SELECT *FROM stu WHERE sid NOT IN(1,2,3)
SELECT *FROM stu WHERE age IS NULL
SELECT *FROM stu WHERE age>20 AND age<40

SELECT *FROM stu WHERE gender IS NOT NULL
SELECT *FROM stu WHERE NAME<>NULL

SELECT *FROM stu WHERE sname LIKE’王_’
SELECT *FROM stu WHERE sname LIKE’王%’

SELECT DISTINCT gender FROM stu

平均
SELECT AVG(age) FROM stu

查询表中所有学生的姓名和对应的英语成绩。
SELECT exam.name,exam.english FROM exam;

删除表中所有记录。
TRUNCATE TABLE employee

删除employee2表
 
DROP TABLE  employee2