Archivi tag: MySQL

MySQL Delete rows subquery You can’t specify target table ‘XXX’ for update in FROM clause

Today my colleague and I have received a gift from MySQL. Our goal was to delete some rows obtaining them using a subquery. Here is the query: And here the response of MySQL You can’t specify target table ‘ps_pack’ for … Continua a leggere

Pubblicato in SQL | Contrassegnato , , | Lascia un commento