- 12.1 Data Definition Statements
- 12.1.1 ALTER DATABASE Syntax
- 12.1.2 ALTER FUNCTION Syntax
- 12.1.3 ALTER PROCEDURE Syntax
- 12.1.4 ALTER TABLE Syntax
- 12.1.5 ALTER VIEW Syntax
- 12.1.6 CREATE DATABASE Syntax
- 12.1.7 CREATE FUNCTION Syntax
- 12.1.8 CREATE INDEX Syntax
- 12.1.9 CREATE PROCEDURE and CREATE FUNCTION Syntax
- 12.1.10 CREATE TABLE Syntax
- 12.1.11 CREATE TRIGGER Syntax
- 12.1.12 CREATE VIEW Syntax
- 12.1.13 DROP DATABASE Syntax
- 12.1.14 DROP FUNCTION Syntax
- 12.1.15 DROP INDEX Syntax
- 12.1.16 DROP PROCEDURE and DROP FUNCTION Syntax
- 12.1.17 DROP TABLE Syntax
- 12.1.18 DROP TRIGGER Syntax
- 12.1.19 DROP VIEW Syntax
- 12.1.20 RENAME TABLE Syntax
ALTER {DATABASE | SCHEMA} [db_name]
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. Section 9.1, “Character Set Support”,
discusses character set and collation names.
You can see what character sets and collations are available
using, respectively, the SHOW CHARACTER
SET and SHOW COLLATION
statements. See Section 12.4.5.3, “SHOW CHARACTER SET Syntax”, and
Section 12.4.5.4, “SHOW COLLATION Syntax”, for more information.
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 Enterprise Monitor 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.