Learning machine learning? Try my machine learning flashcards or Machine Learning with Python Cookbook.

Delete Rows

17 Jun 2018

Create Table

-- Create table called adventurers
CREATE TABLE adventurers (
    -- string variable
    name varchar(255),
    -- integer variable
    age int,
    -- string variable
    race varchar(255),
    -- string variable
    weapon varchar(255)
)

Insert Rows

-- Insert into the table adventurers
INSERT INTO adventurers (name, age, race, weapon)
VALUES ('Fjoak Doom-Wife', 28, 'Human', 'Axe'),
       ('Alooneric Cortte', 29, 'Human', 'Bow'),
       ('Piperel Ramsay', 35, 'Elf', 'Bow'),
       ('Casimir Yardley', 14, 'Elf', 'Bow')

View Table

-- Retrieve all rows
SELECT * FROM adventurers

name	age	race	weapon
Fjoak Doom-Wife	28	Human	Axe
Alooneric Cortte	29	Human	Bow
Piperel Ramsay	35	Elf	Bow
Casimir Yardley	14	Elf	Bow

Delete All Rows

-- Delete rows
DELETE FROM adventurers
-- Where the race column is human
WHERE race = 'Human'

View Table

-- Retrieve all rows
SELECT * FROM adventurers

name	age	race	weapon
Piperel Ramsay	35	Elf	Bow
Casimir Yardley	14	Elf	Bow