Updation of multiple records in MYSql db [modified]
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Hi, I have a table whose data is displayed in a datagrid as follows Emp_id Emp_name Other_data 12 aa ... 13 bb ... 14 cc ... Is there any way that instead of writing a query for each and every record, i can use a single query for updating all records..? (The data is updated in bulk) The backend being used is MYSQL so using arrays in a procedure is not working.. i supose it is not supported in MySQL.. Thanks. -- modified at 4:25 Monday 30th April, 2007