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

Copy Table Structure

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)
)

Create New Table Using Existing Table’s Structure

-- Create table called adventurers_copy using the same columns as...
CREATE TABLE adventurers_copy AS (
    -- The adventurers table
    SELECT * FROM adventurers
)