create database kensproblem; create table the_table (field_A int, field_B int, field_c int, field_d int, field_e int, field_f int); insert into the_table values (0,0,0,0,0,0); insert into the_table values (0,1,0,1,0,1); insert into the_table values (0,2,0,2,0,2); insert into the_table values (4,3,4,3,4,3); insert into the_table values (0,3,4,3,4,3); update the_table set field_a=field_b, field_c=field_d where field_a=0;
select * from the_table; +---------+---------+---------+---------+---------+---------+ | field_A | field_B | field_c | field_d | field_e | field_f | +---------+---------+---------+---------+---------+---------+ | 0 | 0 | 0 | 0 | 0 | 0 | | 1 | 1 | 1 | 1 | 0 | 1 | | 2 | 2 | 2 | 2 | 0 | 2 | | 4 | 3 | 4 | 3 | 4 | 3 | | 3 | 3 | 3 | 3 | 4 | 3 | +---------+---------+---------+---------+---------+---------+ Works for me! > You can't reproduce this with a simple example using the data you've > supplied, so there are other clues we cannot guess. How about showing > us the real table structure and the real commands you used? -- Ted Roche Ted Roche & Associates, LLC http://www.tedroche.com _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
