SQL Commands

sqlCommands.txt

//create db
CREATE DATABASE db_name;

//create table
CREATE TABLE table_name
(
  col1_name datatype,
  col2_name datatype,
  col3_name datatype,
  ...
);

//drop table
DROP TABLE table_name;

//datatypes
int, varchar(length)

//get data
SELECT col1_name, col2_name, ... FROM table_name WHERE col_name = col_value ORDER BY col_name order_how;

//update table
UPDATE table_name SET col_name = new_value WHERE col_name = col_value;

//insert
INSERT into table_name (col1_name, col2_name, col3_name...) VALUES (value1, value2, value3...);

//aggregate functions
count, sum, avg, max, min