mysql数据库的增、删、改、查

1.创建数据库

MariaDB [(none)]> create database bee;

2.查看数据库

MariaDB [(none)]> show databases;

3.删除数据库

MariaDB [bee]> drop database bee;

4.引用数据库

MariaDB [(none)]> use bee;

5.创建表

MariaDB [bee]> create table bumen(bumen_id int,bumen_name varchar(50));

6.查看表

MariaDB [bee]> show tables;

7.删除表

MariaDB [bee]> drop table bumen;

​8.插入数据（行）

MariaDB [bee]> insert into bumen values(1,"运维部");

9.查看表字段（行）

MariaDB [bee]> select * from bumen;

10.修改行

MariaDB [bee]> update bumen set bumen_name='开发部' where bumen_id=1;

11.删除行

MariaDB [bee]> delete from bumen where bumen_id=1;

​