[SQL] Duplicate column + values in table
Solved
DjSKeud
Posted messages
103
Status
Membre
-
DjSKeud Posted messages 103 Status Membre -
DjSKeud Posted messages 103 Status Membre -
Hello,
Is it possible to duplicate, in a table, a column "A" to a column "B"? The column "B" already exists, but I want each field "B" of each record to take the value of the field "A" from the same record.
WARNING: There's no need to tell me to use a loop... that's not my question! (A loop would take too long in my case: 10,000 lines :s)
Thank you in advance for your answers.
DjSkeud,
http://tomleskeud.free.fr
Is it possible to duplicate, in a table, a column "A" to a column "B"? The column "B" already exists, but I want each field "B" of each record to take the value of the field "A" from the same record.
WARNING: There's no need to tell me to use a loop... that's not my question! (A loop would take too long in my case: 10,000 lines :s)
Thank you in advance for your answers.
DjSkeud,
http://tomleskeud.free.fr
Configuration: Windows XP Internet Explorer 6.0
