6.3

Create a Duplicate Table From An Existing Table

Create a Duplicate Table from an Existing Table with a Select Statement

  • It is often helpful to create a duplicate table from an existing table for testing purposes
  • You can combine the CREATE TABLE command with a select statement to create a duplicate of a table structure as well as the data in the table.

Code Sample:

1    USE world; 
2    CREATE TABLE city_bak AS SELECT * FROM city;

Results:

sub_03.png

USE world;

CREATE TABLE city_bak AS SELECT * FROM city;

This content is provided to you freely by BYU-I Books.

Access it online or download it at https://books.byui.edu/learning_mysql/create_a_duplicate_t.