I'm making a script that generates test sites usíng dummy data stored in one
MySql database ("uwebsitebase")
Now, using php-scripting, I'm copying these data to a demo-database
("uwebdemo"). The structure is the same - the same tables with the same
fields. Only difference will be that the copied data should get new primary
keys which are auto-incremented. No problem there.
However, the process is tedious. I have tables that contains some 30 fields
and it's just a bore selecting all fields from one table, and then writing a
complete insert statement with all the fields except the PK.
Is there an easier way? Remember 1) It's PHP 2) It's across databases.
I have to script it, since I need the new keys on other places.
- Carsten
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
