Stored procedure

Question

Table consists 100 records. table have two fields like x and y. in x field 4 values like (A,B,C,D) Here values are not static dynamic may change in another record

 

Need to fill Y field like (Hi,Hi,Hi,Hi)

 

i can have code in c# need MySql Code

 

for ( int i = 0 ; i < 100 ; i++) //table records count

{

int count = X.count; // X field values count

for ( count = 0 ; count < count.length ; count++) // values count in field

{

Update table.y = "HI,Hi,Hi,Hi" ;

}

}