Answers for "sql create table with values"

SQL
1

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);
Posted by: Guest on October-27-2020
0

sql create table

CREATE TABLE li_wedding (
   guest_id INT,
   last_name VARCHAR(255),
   first_name VARCHAR(255),
   attending BOOL,
   diet VARCHAR(255)
);
Posted by: Guest on July-03-2021

Code answers related to "sql create table with values"

Code answers related to "SQL"

Browse Popular Code Answers by Language