数据库创建步骤

创建数据库的步骤

 

mysql> CREATE DATABASE icoast;

Query OK, 1 row affected

mysql> SHOW DATABASES;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| icoast             |

| mysql              |

| performance_schema |

| test               |

+--------------------+

5 rows in set

 

mysql> SHOW CREATE DATABASE icoast;

+----------+----------------------------------------------------------------+

| Database | Create Database                                                |

+----------+----------------------------------------------------------------+

| icoast   | CREATE DATABASE `icoast` /*!40100 DEFAULT CHARACTER SET gbk */ |

+----------+----------------------------------------------------------------+

1 row in set

 

mysql> ALTER DATABASE icoast DEFAULT CHARACTER SET utf8;

Query OK, 1 row affected

 

 

mysql> SHOW CREATE DATABASE

icoast;

+----------+-----------------------------------------------------------------+

| Database | Create Database                                                 |

+----------+-----------------------------------------------------------------+

| icoast   | CREATE DATABASE `icoast` /*!40100 DEFAULT CHARACTER SET utf8 */ |

+----------+-----------------------------------------------------------------+

1 row in set

 

mysql> DROP DATABASE icoast;

Query OK, 0 rows affected

 

mysql> SHOW DATABASES;

+--------------------+

| Database           |

+--------------------+

| information_schema |

| mysql              |

| performance_schema |

| test               |

+--------------------+

4 rows in set

 

mysql>