Skip to content

Latest commit

 

History

History
560 lines (462 loc) · 8.57 KB

query_log.md

File metadata and controls

560 lines (462 loc) · 8.57 KB
SELECT * FROM baskin_icecream WHERE Flavour='Green Tea';
DELETE FROM baskin_icecream WHERE id=1;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream;
DELETE FROM baskin_icecream WHERE id=1;
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream WHERE Flavour='Green Tea';
DELETE FROM baskin_icecream WHERE id=1;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream;
DELETE FROM baskin_icecream WHERE id=1;
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream WHERE Flavour='Green Tea';
DELETE FROM baskin_icecream WHERE id=1;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream;
DELETE FROM baskin_icecream WHERE id=1;
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream WHERE Flavour='Green Tea';
DELETE FROM baskin_icecream WHERE id=1;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream;
DELETE FROM baskin_icecream WHERE id=1;
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream WHERE Flavour='Green Tea';
DELETE FROM baskin_icecream WHERE id=1;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream;
DELETE FROM baskin_icecream WHERE id=1;
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
DELETE FROM baskin_icecream WHERE id=1;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream;
SELECT * FROM baskin_icecream WHERE Flavour='Green Tea';
SELECT * FROM baskin_icecream WHERE Flavour='Green Tea';
SELECT * FROM baskin_icecream WHERE Flavour='Green Tea';
SELECT * FROM baskin_icecream WHERE Flavour='Green Tea';
SELECT * FROM baskin_icecream WHERE Flavour='Green Tea';
DELETE FROM baskin_icecream WHERE id=1;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream;
DELETE FROM baskin_icecream WHERE id=1;
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream WHERE Flavour='Green Tea';
DELETE FROM baskin_icecream WHERE id=1;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream;
DELETE FROM baskin_icecream WHERE id=1;
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream WHERE Flavour='Green Tea';
DELETE FROM baskin_icecream WHERE id=1;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream;
DELETE FROM baskin_icecream WHERE id=1;
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream WHERE Flavour='Green Tea';
DELETE FROM baskin_icecream WHERE id=1;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream;
DELETE FROM baskin_icecream WHERE id=1;
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream WHERE Flavour='Green Tea';
DELETE FROM baskin_icecream WHERE id=1;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'
SELECT * FROM baskin_icecream;
INSERT INTO baskin_icecream VALUES (
            Butterscotch, 
            114, 
            7.5, 
            0.4, 
            25, 
            18, 
            2.2, 
            kids70g);
SELECT * FROM baskin_icecream;
DELETE FROM baskin_icecream WHERE id=1;
SELECT * FROM baskin_icecream WHERE Flavour = 'Butterscotch'