MySQL Practice, MySQL

MySQL Practice

CREATE TABLE PUPPIES_ALL (id INTEGER PRIMARY KEY,
    breed TEXT,
    type TEXT,
    division TEXT, 
    class INTEGER,                       
    ironium_alert INTEGER);

INSERT INTO EO_Incidents25 VALUES(1, "Pomeranian", "HZ Expansion", "Operations", 3, 1);
INSERT INTO EO_Incidents25 VALUES(2, "Corgi", "HZ Expansion", "Operations", 3, 1);
INSERT INTO EO_Incidents25 VALUES(3, "King Charles Spaniel", "HZ Expansion", "Operations", 3, 1);
INSERT INTO EO_Incidents25 VALUES(4, "Labradoodle", "HZ Expansion", "Operations", 3, 1);
INSERT INTO EO_Incidents25 VALUES(5, "Dalmatian", "Override Escalation", "Support", 1, 0);
INSERT INTO EO_Incidents25 VALUES(6, "Maltese", "Override Escalation", "Security", 1, 0);
INSERT INTO EO_Incidents25 VALUES(7, "Golden Retriever", "Override Escalation", "Security", 1, 0);
INSERT INTO EO_Incidents25 VALUES(8, "German Shepherd", "Override Escalation", "Operations", 1, 0);
INSERT INTO EO_Incidents25 VALUES(9, "Poodle", "Override Escalation", "Operations", 1, 0);
INSERT INTO EO_Incidents25 VALUES(10, "Leonberger", "Override Escalation", "Operations", 1, 0);
INSERT INTO EO_Incidents25 VALUES(11, "Shiba Inu", "Prank Call", "Operations", 1, 0);
INSERT INTO EO_Incidents25 VALUES(12, "Pug", "Conference", "Operations", 1, 0);
INSERT INTO EO_Incidents25 VALUES(13, "Saint Bernard", "Prank Call", "Operations", 1, 0);
INSERT INTO EO_Incidents25 VALUES(14, "Boxer", "Conference", "Operations", 1, 0);
INSERT INTO EO_Incidents25 VALUES(15, "Akita", "Visitor", "Operations", 1, 1);
INSERT INTO EO_Incidents25 VALUES(16, "Beagle", "Explosive", "Operations", 5, 4);
INSERT INTO EO_Incidents25 VALUES(17, "Bernese Mountain Dog", "Suspicious Person", "Security", 2, 1);
INSERT INTO EO_Incidents25 VALUES(18, "Puggle", "Conference", "Security", 1, 0);
INSERT INTO EO_Incidents25 VALUES(19, "Basset Hound", "Override Escalation", "Security", 1, 0);
INSERT INTO EO_Incidents25 VALUES(20, "Pekingese", "Override Escalation", "Operations", 1, 0);


run \| edit \| history \| help	0