efi 用户 nec 关系 tor select语句 mysql 底层 lte
MySQL数据库以及表的管理
作者:尹正杰
- mysql> help create database
- Name: ‘CREATE DATABASE‘
- Description:
- Syntax:
- CREATE {DATABASE | SCHEMA} [IF NOT EXISTS] db_name
- [create_specification] ...
- create_specification:
- [DEFAULT] CHARACTER SET [=] charset_name #设置字符集
- | [DEFAULT] COLLATE [=] collation_name #设置排序方式
- CREATE DATABASE creates a database with the given name. To use this
- statement, you need the CREATE privilege for the database. CREATE
- SCHEMA is a synonym for CREATE DATABASE.
- URL: http://dev.mysql.com/doc/refman/5.1/en/create-database.html
- mysql>
- mysql> show databases;
- +--------------------+
- | Database |
- +--------------------+
- | information_schema |
- | mysql |
- | test |
- +--------------------+
- 3 rows in set (0.00 sec)
- mysql>
- mysql> create database yinzhengjie;
- Query OK, 1 row affected (0.01 sec)
- mysql> show databases;
- +--------------------+
- | Database |
- +--------------------+
- | information_schema |
- | mysql |
- | test |
- | yinzhengjie |
- +--------------------+
- 4 rows in set (0.00 sec)
- mysql>
- mysql> show databases;
- +--------------------+
- | Database |
- +--------------------+
- | information_schema |
- | mysql |
- | test |
- | yinzhengjie |
- +--------------------+
- 4 rows in set (0.00 sec)
- mysql> create database if not exists yinzhengjie;
- Query OK, 1 row affected, 1 warning (0.00 sec)
- mysql> show databases;
- +--------------------+
- | Database |
- +--------------------+
- | information_schema |
- | mysql |
- | test |
- | yinzhengjie |
- +--------------------+
- 4 rows in set (0.00 sec)
- mysql>
MySQL数据库以及表的管理
来源: http://www.bubuko.com/infodetail-2398813.html