Database create , delete and list using query

Database is a collection of structured information or data.

Creating a database

CREATE DATABASE my_database;

If the database is already there then MySQL will return error. We can check first before creating the database.

CREATE database IF NOT EXISTS  my_database;

The user account must have privileges to create database. Contact your database admin to get required privilege if you are getting ERROR 1044 (42000): Access denied for user message.

To know which database is currently in use

SELECT DATABASE()

Listing all Databases

SHOW databases;

We can use LIKE to filter the listing of database

SHOW databases LIKE '%plus2%';

This will list all databases having plus2 any where in the database name.

More on SHOW Database and table

Opening a Database

Creating a database does not mean it is selected for use. We have to explicitly call it before using.

USE my_database;

With this our my_database is available to us.

In windows we can refer the database or the table names in upper or lower case as there is no restriction on case, but under UNIX system all names are case-sensitive.

Deleting Database

DROP DATABASE my_database;

If the database is not available then this will generate error, so we can check before deleting.

DROP DATABASE IF EXISTS my_database;

PHP Script to List all Databases
SQL Show all tables in Database How to delete table or database

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

DATABASE Create display and delete

Listing all Databases

Opening a Database

Deleting Database

Subhendu Mohapatra