[Resolved] copy a record

[mojodojo]

I want to do this sort of thing:

insert into inventory (select * from inventory where itemID = '7')

The problem is that it wants to copy the itemID which is a primary autocount # also. How could I copy a whole record without it copying the itemID. I would prefer not to use each of the field names instead of . So is there a way to select minus a field. I just want to keep the code flexible for future additions to my site without having to keep updating this page when new fields are added.

Thanks

[LordShryku]

You'll have to specify columns.

[matjaz]

instead of spending 5 min to ask this you could write column names 😉

[mojodojo]

Is that something I have to do or can it be done otherwise. I just like to build pages thinking abut future expansion. When i add columns to the database, I am going to have to modify this file along with many other ones. I guess spending five minutes to post this would save me time and possible headaches in the future.

Thanks

[LordShryku]

If you're wanting to save room for expansion, create a function to grab all of the table columns (see [man]mysql_list_fields[/man]), strip out the id column and return the list of columns.

[mojodojo]

Sweet, thanks I like that option alot.