(mysql.info) alter-database
情報カタログ
(mysql.info) data-definition
(mysql.info) data-definition
(mysql.info) alter-table
13.1.1 `ALTER DATABASE' Syntax
------------------------------
ALTER {DATABASE | SCHEMA} [DB_NAME]
ALTER_SPECIFICATION [, ALTER_SPECIFICATION] ...
ALTER_SPECIFICATION:
[DEFAULT] CHARACTER SET CHARSET_NAME
| [DEFAULT] COLLATE COLLATION_NAME
`ALTER DATABASE' enables you to change the overall characteristics of a
database. These characteristics are stored in the `db.opt' file in the
database directory. To use `ALTER DATABASE', you need the `ALTER'
privilege on the database. `ALTER SCHEMA' is a synonym for `ALTER
DATABASE' as of MySQL 5.0.2.
The `CHARACTER SET' clause changes the default database character set.
The `COLLATE' clause changes the default database collation.
charset, discusses character set and collation names.
The database name can be omitted, in which case the statement applies
to the default database.
情報カタログ
(mysql.info) data-definition
(mysql.info) data-definition
(mysql.info) alter-table
より自動的に生成されましたinfo2html