[Ilugc] create table from an existing table using MySQL

From: karthikeyan.balasubramanian@xxxxxxxxxxxxx (Karthikeyan)
Date: Mon Aug 2 15:59:22 2004

Hi,

Hi all,

How do I create a table xyz from an existing table abc in MySQL?

Thanks in advance

Eshwar

You can try this

CREATE TABLE xyz AS SELECT * FROM abc

HTH

Karthikeyan B

References:
- [Ilugc] create table from an existing table using MySQL
  - From: Eshwar Ponraj

Other related posts:

» [Ilugc] create table from an existing table using MySQL- Eshwar Ponraj
» [Ilugc] create table from an existing table using MySQL - Karthikeyan