Mysql update does not allow reference update tablehttps://stackoverflow.com/questions/37251621/how-to-resolve-mysql-error-you-cant-specify-target-table-x-for-update-in-fromhttps://stackoverflow.com/questions/13188603/cant-specify-target-table-for-update-in-from-clause