why use create table code example
Example: 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');