-
SHOW {DATABASES | SCHEMAS} [LIKE '
pattern
' | WHEREexpr
]SHOW DATABASES
lists the databases on the MySQL server host.SHOW SCHEMAS
is a synonym forSHOW DATABASES
. TheLIKE
clause, if present, indicates which database names to match. TheWHERE
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 SETcharset_name
| [DEFAULT] COLLATEcollation_name
CREATE DATABASE
creates a database with the given name. To use this statement, you need theCREATE
privilege for the database.CREATE SCHEMA
is a synonym forCREATE DATABASE
. (注意:我使用的是MySQL 5.1,使用小写字母报语法错误)。 -
USE
db_name
The
USE
statement tells MySQL to use thedb_name
db_name
database as the default (current) database for subsequent statements. The database remains the default until the end of the session or anotherUSE
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,使用小写字母报语法错误)
-
INSERT Syntax
-
MySQL的安装:关键在于Character Set选项应选择gb或gb2321
mysql-gui-tools-5.0-r12-win32.msi的安装:(MySQL图形化管理工具)