[thelist] MySQL/PHP - copy record?

Anthony Baratta Anthony at Baratta.com
Tue Aug 13 13:58:01 CDT 2002


At 11:12 AM 8/13/2002, Bill Haenel wrote:

>I wonder, though, is there a way to do this without specifying each field
>name? It would be nice to not have to go back and edit the code much later
>if I decide to add fields or something. Plus, I have many fields in this
>particular table, so it would be cool to somehow shorten it. '*' wouldn't
>work of course, because it would copy the entire record, and I need a new
>date and id. Is there an "ALL BUT" or something?

Not that I'm aware of. If you want to make it a bit easier in yourself, you
could put all the column names in an array and build the SQL statement with
that.
---
Anthony Baratta
President
Keyboard Jockeys

"Conformity is the refuge of the unimaginative."




More information about the thelist mailing list