DATABASE Create display and delete
Database is a collection of structured information or data.
Creating a database
If the database is already there then MySQL will return error. We can check first before creating the database.
CREATE DATABASE my_database;
CREATE database IF NOT EXISTS my_database;
Listing all Databases
We can use LIKE to filter the listing of database
This will list all databases having plus2 any where in the database name.
SHOW databases LIKE '%plus2%';
More on SHOW Database and table
Opening a Database
With this our my_database is available to us.
If the database is not available then this will generate error, so we can check before deleting.
DROP DATABASE my_database;
DROP DATABASE IF EXISTS my_database;
SQL Show all tables in DatabaseHow to delete tabel or database
This article is written by plus2net.com team.
▼ More on Math functions in SQL