- 13.1 Data Definition Statements
- 13.1.1 ALTER DATABASE Syntax
- 13.1.2 ALTER TABLE Syntax
- 13.1.3 ALTER LOGFILE GROUP Syntax
- 13.1.4 ALTER TABLESPACE Syntax
- 13.1.5 ALTER SERVER Syntax
- 13.1.6 CREATE DATABASE Syntax
- 13.1.7 CREATE INDEX Syntax
- 13.1.8 CREATE TABLE Syntax
- 13.1.9 CREATE LOGFILE GROUP Syntax
- 13.1.10 CREATE TABLESPACE Syntax
- 13.1.11 CREATE SERVER Syntax
- 13.1.12 DROP DATABASE Syntax
- 13.1.13 DROP INDEX Syntax
- 13.1.14 DROP TABLE Syntax
- 13.1.15 DROP LOGFILE GROUP Syntax
- 13.1.16 DROP TABLESPACE Syntax
- 13.1.17 DROP SERVER Syntax
- 13.1.18 RENAME DATABASE Syntax
- 13.1.19 RENAME TABLE 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.
The CHARACTER SET clause changes the default
database character set. The COLLATE clause
changes the default database collation.
Chapter 10, Character Set Support, discusses character set and collation
names.
The database name can be omitted, in which case the statement applies to the default database.
MySQL Enterprise. In a production environment, alteration of a database is not a common occurrence and may indicate a security breach. Advisors provided as part of the MySQL Network Monitoring and Advisory Service automatically alert you when data definition statements are issued. For more information see, http://www.mysql.com/products/enterprise/advisors.html.
User Comments
Add your own comment.