On Sat, 2001-11-03 at 08:33, [EMAIL PROTECTED] wrote: > Hi. I have already written a php / mysql search engine, so i have a > vague idea of what i'm doing. But i do have a query no seems to > be able to answer. > > Is it possable to copy a row from one table, to another table? > Both tables have the same field names, and settings. And i can > easily "insert" data manually. But i was wondering if i could simply > "copy" the data from DB to DB > > TIA > Do you want to copy from table to table, or db to db? You switch between the two.
For the first, see the INSERT INTO table SELECT ... syntax. For the second, extend that by using the db.table syntax for the table you're selecting from. Steve Meyers --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
