Alter database syntax

ALTER DATABASE db_name alter_specification [, alter_specification] ….

alter_specification: [DEFAULT] CHARACTER SET charset_name

[DEFAULT] COLLATE collation_name

ALTER DATABASE allows you to change the overall characteristics of a database.

The CHARACTER SET clause changes the database character set. The COLLATE clause changes the database collation.

Database 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 DATABASE was added in MySQL 4.1.1.