mysql

发布时间 2023-06-19 10:01:33作者: zmm521

创建库

create database db1

查看库

show database

切换当前库

use db1

删除库

drop database db1

 

创建表

create table students

清空表

delete from 表名

语法:insert into 表名(列1,列2...values(值,值...)

Eg: insert into students(name,sex,age) values(zm,male,18)

语法:delete from 表名 [where =]

Eg:delete from students where name=zm

语法:update 表名 set =[where =]

Eg:update students set age=19 where name=zm’ 

语法:select * from 列表 【where =值】

Eg:select name from students where age=19