mysql数据库增删改查基础语句_Mysql数据库基础增删改查常用语句命令

Mysql增删改查常用语句命令

一、增删改查语句总览

创建： create(创建数据库)

增：insert(插入表数据)

删：drop、delete(删除表、删除表数据)

改：update、alter(更改表数据、插入新字段)

查：select、show、describe/desc(查询表数据、查看所有表、查看表结构)

二、创建、删除数据库

创建mydatabase数据库

mysql> create database mydatabase;

Query OK, 1 row affected (0.06 sec)

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mydatabase |

| mysql |

| performance_schema |

| sys |

+--------------------+

5 rows in set (0.00 sec)

删除mydatabase数据库

mysql> drop database mydatabase;

Query OK, 0 rows affected (0.00 sec)

mysql> show databases;

+--------------------+

| Database |

+--------------------+

| information_schema |

| mysql |

| performance_schema |

| sys |

+--------------------+

4 rows in set (0.00 sec)

三、对数据库表的操作

在mydatabase数据库中创建表stu

mysql> use mydatabase;

Database changed

mysql> create table stu(id int(10),name varchar(10),class varchar(10));

Query OK, 0 rows affected, 1 warning (0.02 sec)

查看表stu

mysql> use mydatabase;

Database changed

mysql> show tables;

+----------------------+

| Tables_in_mydatabase |

+----------------------+

| stu |

+----------------------+

1 row in set (0.00 sec)

或者

mysql> describe table stu;

+----+-------------+-------+------------+------+---------------+------+---------+------+------+----------+-------+

| id