[SQL]: Commands
SQL
09/18/2019
List of SQL commands
SQL
show databases; -- show databasesCREATE DATABASE <name> -- <name> used for placeholderDROP DATABASE <db_name>;DROP DATABASE IF EXISTS <db_name>; # example of if stmtUSE <db_name>;SELECT databse(); -- show db being usedSELECT * from <table_name>;DELETE FROM <table_name> WHERE <col_name>="data";DROP TABLE <table_name>;
List of MySQL commands
SQL