Hi ,
I want to update table such that

data in excel sheet

A1=first row of A colum
B1=second row of B colum

update T1 set col1=B1 where col2=A1
update T1 set col1=B2 where col2=A2

insufficient information

please do a SHOW CREATE TABLE for the table

how are you reading the excel sheet?

SHOW CREATE TABLE T1 (
a bigint not null primary key auto_increment,
b varchar (64) not null ,
)



I want update A1 column to B1 column of excell
A2 to B2 and so on

where A1 refers to a column of table T1
and B2 refers to b column of table T1