Oracle分析函数参考手册

最新推荐文章于 2024-08-27 13:31:04 发布

jbossllx

最新推荐文章于 2024-08-27 13:31:04 发布

阅读量256

点赞数

文章标签： oracle database mysql character collation schema

本文链接：https://blog.csdn.net/jbossllx/article/details/2216760

版权

```
SHOW {DATABASES | SCHEMAS}
    [LIKE 'pattern' | WHERE expr]
```
SHOW DATABASES lists the databases on the MySQL server host. SHOW SCHEMAS is a synonym for SHOW DATABASES. The LIKE clause, if present, indicates which database names to match. The WHERE clause can be given to select rows using more general conditions 。具体见Manual
```
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. （注意：我使用的是MySQL 5.1，使用小写字母报语法错误）。
```
USE db_name
```
The USE db_name statement tells MySQL to use the db_name database as the default (current) database for subsequent statements. The database remains the default until the end of the session or another USE statement is issued:
```
USE db1;
SELECT COUNT(*) FROM mytable;   # selects from db1.mytable
USE db2;
SELECT COUNT(*) FROM mytable;   # selects from db2.mytable
```

CREATE TABLE Syntax（注意：我使用的是MySQL 5.1，使用小写字母报语法错误）

MySQL的安装：关键在于Character Set选项应选择gb或gb2321

	mysql-gui-tools-5.0-r12-win32.msi的安装：（MySQL图形化管理工具）

关注