ALTER DATABASE command helps to modify database specification and also help to rename database;
Syntax
ALTER {DATABASE | SCHEMA} [db_name]
alter_specification ...
ALTER {DATABASE | SCHEMA} db_name
UPGRADE DATA DIRECTORY NAME
alter_specification:
[DEFAULT] CHARACTER SET [=] charset_name
| [DEFAULT] COLLATE [=] collation_name
Modifying DATABASE specification
mysql> alter database javaskool_inventory
-> DEFAULT CHARACTER SET latin1
-> DEFAULT COLLATE latin1_bin;
Query OK, 1 row affected (0.07 sec)
mysql>
Recent Comments