Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

copying tables

Status
Not open for further replies.

thumbelina

Programmer
Jun 4, 2001
58
CA
ok i have one table set up as a template so that i can copy it and have one table for each employee. the code for this is: CREATE TABLE newtablename SELECT * FROM orginaltable
now this does copy the table but the field entryID is auto_increment and primary key and these two detials of that field doesn't get copied into the new table, but everything else seems to have come out fine. anythoughts??
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top