w3schools sql create table from table code example
Example 1: create table sql
CREATE TABLE table_name(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(255), # String 255 chars max
date DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
longtext BLOB
);
Example 2: how to create table in sql
# Creates a Simple User table
# Uses an auto-incrementing primary key as userId
CREATE TABLE user (
userId INT NOT NULL AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(100),
password VARCHAR(100)
) ENGINE=InnoDB;