mysql 基本语句查询

像笔记本一样，忘记就来查查。

CREATE DATABASE teacher;//创建数据库名为teacher

DROP DATABASE student;//删除student数据库

CREATE TABLE teacher_name(
id INT(11),
name VARCHAR(25),
age INT(2)
);//在teacher数据库中创建表teacher_name

DROP TABLE teacher_name;//删除数据表teacher_name

INSERT INTO teacher_name (id,name,age)
VALUES(002,'张老师',23);//向teacher_name表中插入一条数据

DELETE FROM teacher_name WHERE id = 001;//删除teacher_name表中id=001的那条数据

SELECT name = '张老师' from teacher_name;//查询teacher_name 表中name= 张老师的数据

UPDATE teacher_name SET name = '老师' WHERE name = '何老师';//将teacher_name表中name=何老师修改成name = 老师