Learning machine learning? Try my machine learning flashcards or Machine Learning with Python Cookbook.
Copy Table Structure
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
)