Updating multiple tables in mssql Video chat gratis deutschland free video chat

Rated 3.90/5 based on 850 customer reviews

We are going to update column DESCRIPTION and PICTURE in table Categories_Test by using data in table Categories, based on data in the common column CATEGORY_ID. Update data in a column in table A based on a common column in table B. Update data in two columns in table A based on a common column in table B. Conditionally update data in table A based on a common column in table B. No portion may be reproduced without my written permission.

The update query below shows that the PICTURE column is updated by looking up the same ID value in CATEGORY_ID column in table Categories_Test and Categories. If you need to update multiple columns simultaneously, use comma to separate each column after the SET keyword. Here we only want to update PICTURE column in Categories_Test table where the data in Category_Name column is Seafood in table Categories. Software and hardware names mentioned on this site are registered trademarks of their respective companies.

However, it seems My SQL does some internal optimizations and runs them very efficiently.

So, the best solution would be to make a logfile and then process this file with a cron job.

It’s very easy to do that, but the challenge lies in updating the database.

Also, keep in mind that in order to gain advantage of My SQL optimizations all those UPDATE queries need to be run in a batch.

Running each UPDATE query when the page is viewed for example is not the same thing (and that’s pretty much the problem I wanted to solve as efficiently as possible).

Leave a Reply