How to create a database in SQL?

To create a database, you can use the CREATE DATABASE statement in SQL. The syntax is as follows:

CREATE DATABASE database_name;

In this case, database_name is the name of the database you want to create. For example, to create a database called mydatabase, you can run the following SQL statement:

CREATE DATABASE mydatabase;

Please note that the specific syntax may vary depending on the database management system being used. Different database management systems may have their own specific syntax and options.