Creating Database in Mysql

Before creating tables in mysql, we have to create database.
command to create database

Command:-

CREATE DATABASE database_name;

Example:-

CREATE DATABASE naikgroup;

To use/choose/enter the database follow this command.

Command:-

USE database_name;

Example:-

USE naikgroup;

Here Naikgroup is database name.

Get list of database in mysql use this command

Syntax:-

SHOW DATABASES;

Note:-

# We can use any word as database name.
# Database name can be combination of Character and number but not number only.
# Number can be used as 1st digit in database name.

List Code:-
Mysql Codes

Next Code:-
Delete Database

4 Comments

  1. I strongly believe that there will be great opportunities for those who looked into this area...
    Best Online Software Training Institute | SQL Server Training

    ReplyDelete
  2. Wonderful article, very useful and well explanation. Your post is extremely incredible.

    ReplyDelete
  3. This is a 2 good post. This post gives truly quality information.

    RPA Training in Hyderabad

    ReplyDelete
  4. Thanks for sharing great information. If anyone looking for the online training mindmajix is the ultimate place to opt for.
    best SQL Server Training

    ReplyDelete

Add your comments here

Back to Top