Updating multiple fields using update query
Support for multi-table updates will be implemented in the near future.
In this tutorial, we’ll go over the various ways to update rows in a table using SQL progressing from more general updates to more specific methods.
If every field needs to be updated to the same value, you can do that using a simple clause as much as you’d like in order to filter down the rows for updating to what you need.
Now what happens if you want to update rows in one table based on the condition of another table?
If it does, then only one of the join rows will be used to update the target row, but which one will be used is not readily predictable.
UPDATE statements are only possible on single tables.tbl_foobar Question ( question_id, foobar Main_id, foobar Question ) tbl_foobar Main ( foobar Main_id, foobar Name, foobar Description ) your database is not normalised as was mentioned before.your answers should be in one table, using an FK to relate them to the questions table.Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.Visit Stack Exchange Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Sign up to join this community I am trying to understand how to UPDATE multiple rows with different values and I just don't get it.