Posted by strawberry on 05/03/06 17:36

It might be easier if we could see the table structure but the answer
could be along these lines...

UPDATE table_2 SET new_field = (SELECT old_field FROM table_1 WHERE
table_1.shared_key = table_2.shared_key);

• Next in forum: Re: Learning php Sql
• Prev in forum: how to store /n and /r from textarea on form in database
• Thread view: Re: Moving a db field

[Reply to this message]