Generate Update Script MySQl Table

Question

I have MySql table that has 250 fields, and i need to do an update, It might take hours to write the entire update manually.

In SQL SERVER, I have the option to "GENERATE UPDATE SCRIPT", I am looking for something like that option.

I tried Phpmyadmin and Navicat, but I don't find such option.

Answer 1

Use describe tablename and copy the fields into excel sheet and then populate the update statement.