Shulou(Shulou.com)06/01 Report--

How does mysql create and open a database? In view of this problem, this article gives the corresponding analysis and answers, hoping to help more friends who want to solve this problem to find a more simple and feasible way.

Mysql commands to create and open the database:

1. Create a database

/ / create the database and set the coding format

Create DATABASE mydb character set utf8

/ / modify the coding format of the database or database table that has been created

Alter database mydb character set utf8;alter table t_name convert to character set utf8

two。 Open the database you just created

Use database name

The above description is the method of creating and opening the database by mysql, and the specific usage needs to be used by everyone through hands-on experiments. If you want to know more about it, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.