General commands

Creating a table

---

 

Syntax 

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

Example

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;

 

View table creation code

SHOW CREATE TABLE `table_name`;