Jacob Uden

Craft 3 insert statements to populate data

Excerpt from the complete ddl: http://sqlfiddle.com/#!9/2047e0

  • October 6, 2016 at 3:45 PM
  • Visible to public
INSERT INTO `food`(`name`, `quantity`)VALUES ('dogChow', '1');
INSERT INTO `food`(`name`, `quantity`) VALUES ('catChow', '1');
INSERT INTO `food`(`name`, `quantity`) VALUES ('whoKnows', '10');
INSERT INTO `species`(`name`, `location`, `diet`) VALUES ('dog', 'backyard', 'dogChow');
INSERT INTO `species`(`name`, `location`, `diet`) VALUES ('cat', 'barn', 'catChow');
INSERT INTO `species`(`name`, `location`, `diet`) VALUES ('barnMouse', 'barn', 'whoKnows');
INSERT INTO `species`(`name`, `location`, `diet`) VALUES ('shedMouse', 'machineShed', 'whoKnows');
INSERT INTO `pets`(`name`, `sex`, `species`, `color`) VALUES ('Zeke', 'm', 'dog', 'black');
INSERT INTO `pets`(`name`, `sex`, `species`, `color`) VALUES ('Mini', 'f', 'cat', 'grey');
INSERT INTO `pets`(`name`, `sex`, `species`, `color`) VALUES ('Junior', 'm', 'cat', 'brown');
INSERT INTO `pets`(`name`, `sex`, `species`, `color`) VALUES ('Screech', 'm', 'cat', 'grey');
INSERT INTO `pets`(`name`, `sex`, `species`, `color`) VALUES ('BigBertha', 'f', 'cat', 'grey');