Sql updating multiple tables at once
In the syntax, you can see the SET keyword and column name is given afterward.Add the possible number of columns here and their respective values too that you wanted to modify.If you are working with multiple databases then start with the location zero from where you want to work with.For this purpose, you can use the “Show Databases” command.The best part is that you don’t have to use SET keywords multiple time even if you are modifying values multiple times. Where clause is optional but it makes your changes more meaningful and up to the mark.
To modify only a selected number of records, you should use where clause smartly.
Further, append one where clause to restrict the modification.