General commands

Creating a table

Syntax Example

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

CREATE TABLE products (
    id INT AUTO_INCREMENT PRIMARY KEY,
    product_name VARCHAR(32),
    company_id INT,
    FOREIGN KEY (company_id) REFERENCES companies(id)
) ENGINE=InnoDB;