Mysql Update Table From Select' title='Mysql Update Table From Select' />My. SQL UPDATE query based on SELECT Query. I found this question in looking for my own solution to a very complex join. This is an alternative solution, to a more complex version of the problem, which I thought might be useful. I needed to populate the productid field in the activities table, where activities are numbered in a unit, and units are numbered in a level identified using a string N, such that one can identify activities using an SKU ie L1. U1. A1. Those SKUs are then stored in a different table. I identified the following to get a list of activityid vs productid SELECT a. FROM activities a. JOIN units USINGunitid. JOIN producttypes USINGproducttypeid. JOIN webproducts w. Boom 1 8 Mac Keygen Program. ON skuCONCATL,SUBSTRproducttypecode,3, U,unitindex, A,activityindex. I found that that was too complex to incorporate into a SELECT within mysql, so I created a temporary table, and joined that with the update statement CREATE TEMPORARY TABLE activityproductids AS lt the above select statement. UPDATE activities a JOIN activityproductids b ON a. SET a. productidb. I hope someone finds this useful. The worlds most popular open source database MySQL. Downloads Documentation Developer Zone Developer Zone Downloads MySQL. Create a MySQL Table Using MySQLi and PDO. The CREATE TABLE statement is used to create a table in MySQL. We will create a table named MyGuests, with five columns. Update Data In a MySQL Table Using MySQLi and PDO. The UPDATE statement is used to update existing records in a table.