examples ////////////////////////////////////////////////////////////////////////

CREATE TABLE table_name (
    column1 datatype,
    column2 datatype,
    column3 datatype
);

CREATE TABLE persons (
    PersonID int,
    LastName varchar(255),
    FirstName varchar(255),
    Address varchar(255),
    City varchar(255)
);

product.sql notes /////////////////////////////////////////////////////////////

CREATE TABLE product (  //table_name use snake_case!!
    id int NOT NULL auto_increment primary key,                                                                             
    name varchar(255),
    quantity int NOT NULL,
    createdAT dateTime DEFAULT NOW(),   //names use camelCase!!
    updatedAT dateTime ON UPDATE NOW()  
);

//show columns from product;
//SELECT * from product; //show everything
//select * from product where quantity = 0;
//select * from product where quantity = 0 ORDER BY name DESC; //descending order z < a
//delete from product where id = 1; //ALWAYS INCLUDE A WHERE (condition!!) 
