SeaCode

Appearance

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;