vendredi 31 juillet 2015

Delete with a SUbquery MySQL

I'm trying to delele with a subquery that is the same table 'carretilla' This works in SQL Server

DELETE FROM carretilla WHERE carcod IN (SELECT carcod  FROM carretilla WHERE TIMESTAMPDIFF(MINUTE,carfch, NOW()) > 10 group BY carcod);

How can i do it? Thanks

Aucun commentaire:

Enregistrer un commentaire