Re: mysql question

Rodney, How much data? And I'm curious as to why you want to do this. Two ways come to mind .. select the data you want fetch it into an array row by row update or insert into the second table using the contents of the array or select the data fetch into an array write it out, comma delimited, to a text file use load data infile (or mysqlimport) to add it to the target table Check the MySQL Utilities part of the MySQL manual. Regards - Miles Thompson Rodney Davis wrote: > I know this isnt a mysql mailing list but I was hoping someone > would have a quick answer for my problem. > > I need to add data from one mysql table to another mysql > table in the same database. I have tried update, select/insert > load data etc and nothing seems to work. > > Could anyone offer some advice? > > thanks > > rodney > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net