How to create table using structure from other table in mysql

Table can be created using create statement. We can create table using following statement like

create table employee (id int(11) not null auto_increment primary key, name varchar(255));

But sometime we need to create a new table based on the content of old table. We use following statement to create new tables based on old tables.

Funding

We need your support to operate it properly. We have lots of ideas but less fund, so help us with your funding.

Thoughts of the day

A perfection of means, and confusion of aims, seems to be our main problem

Albert Einstein
Sell your product online

Do you want to sell products online with no extra cost?

Send your details, our executive will contact you

Email:

Mobile:

Location:

Polls
What you like most in facebook?
News
50%

 


Games
50%

 


Images

Videos

Tutorial On Request
Q. Ask us for any tutorial or any thing which helps to build your career better.
Email:
Query: