Insert Rows

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 Row

-- Insert row into the table adventurers
INSERT INTO adventurers (name, age, race, weapon)
VALUES ('Fjoak Doom-Wife', 28, 'Human', 'Axe')

Retrieve Rows

-- Retrieve all rows from table
SELECT * FROM adventurers
nameageraceweapon
Fjoak Doom-Wife28HumanAxe

Insert Rows

-- Insert rows into the table adventurers
INSERT INTO adventurers (name, age, race, weapon)
VALUES ('Alooneric Cortte', 29, 'Elf', 'Bow'),
       ('Piperel Ramsay', 35, 'Elf', 'Sword'),
       ('Casimir Yardley', 14, 'Elf', 'Magic')

Retrieve Rows

-- Retrieve all rows from table
SELECT * FROM adventurers
nameageraceweapon
Fjoak Doom-Wife28HumanAxe
Alooneric Cortte29ElfBow
Piperel Ramsay35ElfSword
Casimir Yardley14ElfMagic