Inserting data while creating a new table.

[NoobLike]

Need some help guys on a query. I need some query for INSERTING a data on a Table while CREATING a new Table.

For Instance:

I have table1 and I inserted some data on it. All i want is to while I'm inserting a data on table1 I'm also creating a new table like table2.


Thanks Guys :)

[coopster]

Seems like a lot extra coding ... why would you want to have duplicate/redundant information in your database?