当前位置：网站首页>mysql 基本语句查询

mysql 基本语句查询

2022-04-23 13:04:00 【孤身不觉晚】

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

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 = 老师

版权声明
本文为[孤身不觉晚]所创，转载请带上原文链接，感谢
https://blog.csdn.net/qq_40043424/article/details/104921898

边栏推荐

猜你喜欢

随机推荐