mysql 语句与实例

1. mysql语句

SQL语句类型	对应操作
DDL	CREATE：创建 DROP：删除 ALTER：修改
DML	INSERT:向表中插入数据 DELETE：删除表中数据 UPDATE：更新表中数据 SELECT：查询表中数据
DCL	GRANT：授权 REVOKE：移除授权

2. mysql 语句语法与实例

2.1 DDL操作 create,drop,alter

2.1.1 数据库操作

//创建数据库
//语法：CREATE DATABASE [IF NOT EXISTS] 'DB_NAME';
//创建数据库xiaoxie
mysql> create database xiaoxie;
Query OK, 1 row affected (0.00 sec)
//再次创建
mysql> create database sanjin;
Query OK, 1 row affected (0.00 sec)
//查看
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sanjin             |
| sys                |
| xiaoxie            |
+--------------------+
6 rows in set (0.00 sec)
//创建重名后报错
mysql> create database sanjin;
ERROR 1007 (HY000): Can't create database 'sanjin'; database exists
//加上if not exists更严谨 
mysql> create database if not exists sanjin ;
Query OK, 1 row affected, 1 warning (0.00 sec)

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sanjin             |
| sys                |
| xiaoxie            |
+--------------------+
6 rows in set (0.00 sec)

//删除数据库
//语法：DROP DATABASE [IF EXISTS] 'DB_NAME';
//删除数据库sanjin
mysql> drop database  xyx;
ERROR 1008 (HY000): Can't drop database 'xyx'; database doesn't exist
mysql> drop