mysql第三章试题_MYSQL 第三章 基操

mysql> show databases; #查看databases 记住后面要加s+--------------------+

| Database |

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

| information_schema |

| employees |

| mysql |

| performance_schema |

| sys |

| test |

| test_db_char |

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

7 rows in set (0.00sec)

mysql> show database like 'te%';

ERROR1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'database like'te%'' at line 1mysql> show databases like 'te%'; #使用 like 关键字进行模糊匹配查询 '%te%' , 'te%' , '%te'+----------------+

| Database (te%) |

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

| test |

| test_db_char |

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

2 rows in set (0.00sec)mysql>show create database test; #查看已经创建的 database 的信息 ，不需要加s+----------+--------------------------------------------------------------------------------+

| Database | Create Database |

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

| test | CREATE DATABASE `test` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_bin*/ |

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

1 row in set (0.00sec)

mysql>create database user_zy; #create 关键字创建数据库

Query OK,1 row affected (0.00sec)

mysql> show create database user_zy; #查看信息+----------+--------------------------------------------------------------------+

| Database | Create Database |

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

| user_zy | CREATE DATABASE `user_zy` /*!40100 DEFAULT CHARACTER SET latin1*/ |

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

1 row in set (0.00sec)mysql>show databases;+--------------------+

| Database |

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

| information_schema |

| employees |

| mysql |

| performance_schema |

| sys |

| test |

| test_db_char |

| user_zy |

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

8 rows in set (0.00sec)

mysql> alter database user_zy default character set utf8; #alter 关键字修改数据库信息

Query OK, 1 row affected (0.00 sec)

mysql> show create database user_zy;

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

| Database | Create Database |

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

| user_zy | CREATE DATABASE `user_zy` /*!40100 DEFAULT CHARACTER SET utf8 */ |

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

1 row in set (0.00sec)

mysql> drop database ifexists user_zy;

Query OK,0 rows affected (0.01sec)