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;

CC BY-NC-ND International 4.0

CC BY-NC-ND International 4.0: This work is released under a CC BY-NC-ND International 4.0 license, which means that you are free to do with it as you please as long as you (1) properly attribute it, (2) do not use it for commercial gain, and (3) do not create derivative works.

End-of-Chapter Survey

: How would you rate the overall quality of this chapter?
  1. Very Low Quality
  2. Low Quality
  3. Moderate Quality
  4. High Quality
  5. Very High Quality
Comments will be automatically submitted when you navigate away from the page.
Like this? Endorse it!