How to Create Database in Mysql:-

Create Database:-

•  In our last tutorial we have configured mysql setup now we are ready to start work with database.
• In this tutorial we will learn how to create database in mysql and how to use them.
• when we install Mysql in our computer it by default create some databases and you can see tham  by command

           Mysql>  show databases;

                      
                         

note- ; to terminate the line of command

• Basic syntax of CREATE DATABASE QUERY in mysql is

         create database database_name;

   for example:-

      mysql> create database tutorialspoint4java;

      mysql> show databases;

now database has been created with name tutorialspoint4java

                      

• In next tutorial we will learn how to create table in database