Create database in mySQL

MySQL CREATE DATABASE

MySQL implements a database as a directory that contains all files which correspond to tables in the database.

To create a new database in MySQL, you use the CREATE DATABASE statement with the following syntax:

CREATE DATABASE [IF NOT EXISTS] database_name
[CHARACTER SET charset_name]
[COLLATE collation_name]

Source: mysqltutorial.org

Mysql create database

CREATE DATABASE mydatabase CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

Create database in mySQL

CREATE DATABASE nameOfYourDatabase;
USE nameOfYourDatabase;
CREATE TABLE nameOfTable(
id INT AUTO_INCREMENT,
   first_name VARCHAR(100),
   last_name VARCHAR(100),
   email VARCHAR(50),
   password VARCHAR(20),
   PRIMARY KEY(id)
);

Similar codes

0 vote299 views1 answer
Show table details postgresql
SQL
3 votes355 views2 answers
Oracle drop sequence
SQL
0 vote294 views1 answer
Sql count more than 1
SQL
5 votes288 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
-1 vote297 views1 answer
Extract Data from SQL Server into XML Format
SQL
1 vote332 views1 answer
Mysql workbench requires visual c++ 2019 redistributable package
SQL
1 vote311 views1 answer
Mysql size int
SQL
0 vote296 views1 answer
Jenkins SQLCMD run
SQL
0 vote310 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
11 votes275 views2 answers
Having keyword sql
SQL