MySQL - UPDATE query based on SELECT Query - Stack ...

2009年8月11日 - SELECT name as name_A, date-time as end_DTS, id as id_A FROM ... You can actually do this one of two ways: MySQL update join syntax:

stackoverflow.com