android - Update column in row - column_1 = column_2 -

i added 1 column table with:

alter table dn_car_repair_options add option_id integer 

now table has next ddl:

create table table_name (id integer primary key,  node_id integer,  name varchar, car_id integer default (0), option_id integer); 

and want update rows (row1)option_id = (row1)id

can make using sqlite?

after creating new column use simple update:

update dn_car_repair_options  set option_id = id; 

without where clause affect rows in table.