sql create table sql cmd code example
Example 1: create table sql
CREATE TABLE vehicle(
vehicleId INT NOT NULL,
make VARCHAR(64),
model VARCHAR(128),
derivative VARCHAR(255),
PRIMARY KEY(vehicleId)
);
INSERT INTO vehicle VALUES(1000,'Volkswagen','Golf','1.5 TSI EVO Match Edition 5dr');
Example 2: sample table creation in sql with data
CREATE TABLE recipe_ingredients (
recipe_id int NOT NULL,
ingredient_id INT NOT NULL,
amount INT NOT NULL,
PRIMARY KEY (recipe_id,ingredient_id)
);
INSERT INTO recipe_ingredients
(recipe_id, ingredient_id, amount)
VALUES
(1,1,1),
(1,2,2),
(1,3,2),
(1,4,3),
(1,5,1),
(2,3,2),
(2,6,1),
(3,5,1),
(3,7,2);