Oracle分析函数参考手册

最新推荐文章于 2025-11-30 20:29:02 发布

原创最新推荐文章于 2025-11-30 20:29:02 发布 · 313 阅读

CC 4.0 BY-SA版权

文章标签：

本文介绍了MySQL中常用的数据库操作命令，包括显示所有数据库、创建数据库、指定默认使用的数据库等。此外还涉及了创建表及插入数据的基本语法，并给出了MySQL安装过程中字符集设置的建议。

```
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图形化管理工具）