create table sql
# 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');