You can actually do this one of two ways: MySQL update join syntax: UPDATE tableA a INNER JOIN tableB b ON a.name_a = b.name_b SET ... ... <看更多>

Based on your question I think you need to include SELECT statement in UPDATE statement : Sample SQL in below: create table test1 (ID int, ... ... <看更多>

MySQL UPDATE Statement is used to modify the contents of an existing ... SQL (Structured Query Language) is the language used to insert and ... ... <看更多>

MySQL - Get id of updated rows. ... mysql_get_last_updated_id.sql ... UPDATE some_table SET column_name = 'value', id = (SELECT @update_id := id). ... <看更多>