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;