var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: how to insert row from select row
i have table A which has the column b as auto increment number, and other column c, d, e
I want to insert one row from the row in exact same table but change the clumn b which is auto increment number
I did like this:
insert into A
select c, d, e from A where b =xxxx
error is: due to key violation,
I don't know how to insert the key into table.
anybody have some idea about this?
thanks a lot. appreciate for your help
Last edited by huela; 09-29-04 at 19:58.