Skip to content

SQL Commands

Create Database

shell
CREATE DATABASE <databasename>;
CREATE DATABASE <databasename>;

Delete Database

shell
DROP DATABASE <databasename>;
DROP DATABASE <databasename>;

List All Databases

shell
SHOW DATABASES;
SHOW DATABASES;

Select Database

shell
use <databasename>;
use <databasename>;

Query Data with Sort

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