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" ;
}
}