RE: MySQL Update based on SELECT CRITERIA

2002-02-14 Thread Roger Baklund
* USER > Is there any way to do an Update...Select like an InsertSelect? > > For instance can I fill one table with data from another table. > The columns > do not match exactly so a table copy won't do much good. But the data > retrieved in the select command is compatible with the new table

MySQL Update based on SELECT CRITERIA

2002-02-13 Thread USER
Is there any way to do an Update...Select like an InsertSelect? For instance can I fill one table with data from another table. The columns do not match exactly so a table copy won't do much good. But the data retrieved in the select command is compatible with the new table fields. sql,que