In my database, I have around 30 tables, each with an
emp_number (INT) column.
How can I update the value of
emp_number in all 30 tables?
|comments disabled on deleted / locked posts|
This question came from our site for professional and enthusiast programmers. Votes, comments, and answers are locked due to the question being closed here, but it may be eligible for editing and reopening on the site where it originated.
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question.If this question can be reworded to fit the rules in the help center, please edit the question.
Now, you may not be expressing your requirement fully. Do you really want to set ALL rows in ALL tables to have the exact same