(mysql.info.gz) ALTER DATABASE

Info Catalog

(mysql.info.gz) Data Definition

(mysql.info.gz) Data Definition

(mysql.info.gz) ALTER TABLE

 
 13.2.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' allows 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.
 
 The `CHARACTER SET' clause changes the default database character set.
 The `COLLATE' clause changes the default database collation.  Character
 set and collation names are discussed in  Charset.
 
 `ALTER DATABASE' was added in MySQL 4.1.1.  Beginning with MySQL 4.1.8,
 the database name can be omitted.  The statement applies to the default
 database in this case.  `ALTER SCHEMA' can be used as of MySQL 5.0.2.
 

Info Catalog

(mysql.info.gz) Data Definition

(mysql.info.gz) Data Definition

(mysql.info.gz) ALTER TABLE