[SQL]: Commands

SQL

09/18/2019


List of SQL commands

SQL
show databases; -- show databases
CREATE DATABASE <name> -- <name> used for placeholder
DROP DATABASE <db_name>;
DROP DATABASE IF EXISTS <db_name>; # example of if stmt
USE <db_name>;
SELECT databse(); -- show db being used
SELECT * from <table_name>;
DELETE FROM <table_name> WHERE <col_name>="data";
DROP TABLE <table_name>;

List of MySQL commands

SQL

WRITTEN BY

Keeping a record