Blog Bustle 11/02/2020
Mysql is free and open source relational database management system(RDBMS). We can create multiple databases into Mysql server.
create database database_name;
This is the query of mysql create database
For example, Let's create student database and query will be
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.