SQL Commands

Create Database

CREATE DATABASE <databasename>;

Delete Database

DROP DATABASE <databasename>;

List All Databases

SHOW DATABASES;

Select Database

use <databasename>;

Query Data with Sort

SELECT * FROM <tablename> ORDER BY <colunm> DESC/ASC limt 10;