sql create table

# Simple table describing a vehicle

CREATE TABLE vehicle(
  	# vehicleId: Unique ID for Primary Key.
  	# This is how we will reference a record
	vehicleId INT NOT NULL,  
  	make VARCHAR(64), # String 64 chars max
  	model VARCHAR(128),
  	derivative VARCHAR(255),
  	PRIMARY KEY(vehicleId)
);

# Add a record
INSERT INTO vehicle VALUES(1000,'Volkswagen','Golf','1.5 TSI EVO Match Edition 5dr');

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
);

# 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;

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) 

);
 

CREATE TABLE table_name (

     column1 datatype,

     column2 datatype,

     column3 datatype,

  
....

); 

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