Posted by Michael Fesser on 05/08/07 13:11
..oO(cluthz)
>I did not actually request all 35 fields, only about 4 of them. I needed to
>do all rows as this is a one off change. Basically on a customer details we
>were moving from storing the email address into the main customer details
>into a separate table so that the customer can have more then one email
>address stored.
Moving data from one table to another can often be done with pure SQL.
Have a look at SELECT INTO or INSERT SELECT statements for example.
Micha
Navigation:
[Reply to this message]
|