How to set up database by sql

This article will explain in detail how to build a database in sql. The editor thinks it is very practical, so I share it with you as a reference. I hope you can get something after reading this article.

CREATE DATABASE is usually used to create a database in MySQL

CREATE DATABASE [IF NOT EXISTS] [[DEFAULT] CHARACTER SET] [[DEFAULT] COLLATE]

Code interpretation:

CREATE DATABASE is followed by the name of the new database, and the purpose of this statement is to create a new database.

If IF NOT EXISTS does not exist, create the database (avoid creating duplicate databases).

DEFAULT CHARACTER character set settings.

DEFAULT COLLATE proofread rule name settings.

Example one

CREATE DATABASE db_test

Example two

This is the end of CREATE DATABASE IF NOT EXISTS test_dbDEFAULT CHARACTER SET utf8DEFAULT COLLATE utf8_chinese_ci; 's article on "how to build a database in sql". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, please share it for more people to see.