6.3

Create a Duplicate Table From An Existing Table

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

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.