how to format sql create 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: create db table
CREATE TABLE table_name (
column1 datatype,
column2 datatype,
column3 datatype,
....
);