Copy Rows From One Table To Another

Create Table Of Adventurers

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

Create Table Of Villains

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

Insert Row Into Adventurers

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

View Adventurers Table

-- Retrieve all rows
SELECT * FROM adventurers
nameagerace
Fjoak Doom-Wife28Human

Copy Rows From Adventurers Table To Villains Table

-- Insert into the villains table
INSERT INTO villains
    (
        -- All rows from adventurers
        SELECT * FROM adventurers
    )

View Villains Table

-- Retrieve all rows
SELECT * FROM villains
nameagerace
Fjoak Doom-Wife28Human