2

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.

Improve this question
3
  • what script language you know? Commented Nov 2, 2012 at 13:10
  • The update is for a php application, do not know if that answers your question shiplu Commented Nov 2, 2012 at 13:14
  • I think someone should consider creating a different database schema that better represents your data. Commented Nov 2, 2012 at 13:23

1 Answer 1

Reset to default
3

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

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.