Hi Brian!
> How do I append one table's contents to another? Both have identical
> structure. Problem is I don't have shell access, only phpAdmin or a
> PHP file I write & upload myself.
You can do it this way:
INSERT INTO table1 SELECT * FROM table2;
If you need to have more control over what is copied, you can add a
WHERE clause in the SELECT above. Also, you can restrict how it is done by
adding some fields restrictions:
INSERT INTO table1 (field1, field2)
SELECT field1, field FROM table2
WHERE field1 = <Some value>
Cheers,
Jose Miguel.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
