SQL Basics
SQL Basics Viewing existing databases: To view existing databases use : SHOW DATABASES; Creating A Database: To create a new database use: CREATE DATABASE [IF NOT EXISTS] database_name ; The database_name is the name of the desired database we want to create, which should be meaningful and descriptive. The IF NOT EXISTS is an optional statement which gives an error while creating a new database if it already exists. (But if the IF NOT EXISTS clause is used in MariaDB it will return a warning instead of an error if the specified database already exists.) Eg. CREATE DATABASE JOHNDRIPPER; Now if we run SHOW DATABASES; again we will see the new database johndripper there. Selecting a Database: To select a database use the query: USE database_name; Eg. USE JOHNDRIPPER; Removing a Database: Removing a database deletes the entire data and all its related objects associated with it permanently therefore us...