Mysql create database

Mysql create database

Blog Bustle 11/02/2020

Mysql is free and open source relational database management system(RDBMS). We can create multiple databases into Mysql server.

Mysql create database syntax

create database database_name;

This is the query of mysql create database

For example, Let's create student database and query will be

mysql create database

If we want to create database which already exists in mysql server then we will get error so before creating database we should check database exists or not.

combined syntax of mysql create database with if database exists

create database if not exists database_name;

You can also check database exists or not by show databases like 'database_name'; query.

You can also create database in mysql by command line.

Database is used to store data. We create tables inside database to store data and We use sql to write query in Mysql.

Queries are used to manage database. We can create and delete database by sql query.

We can also get a list of all databases and select database by sql query.

Mysql uses Apache web server. Apache http server is free open source web server software.

We can add multiple users to single database.

We can also give permission to users about what are their tasks.

Other important links

Create database in mysql from command line

Show database in mysql

Delete database in mysql

Select database in mysql

Mysql create database searches:

Tags: #mysql