DELETE FROM `accounts` as ACCS WHERE `id` > 40 AND `creation` <= 9959595 AND (SELECT COUNT(*) FROM `players` WHERE `account_id` = `ACCS`.`id`) > 0;
está retornando o error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as ACCS WHERE `id` > 40 AND `creation` <= 9959595 AND (SELECT COUNT(*) FROM `pla' at line 1
Syntax Error
em MySQL
Postado
Oi, alguém poderia me ajudar?
DELETE FROM `accounts` as ACCS WHERE `id` > 40 AND `creation` <= 9959595 AND (SELECT COUNT(*) FROM `players` WHERE `account_id` = `ACCS`.`id`) > 0;
está retornando o error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as ACCS WHERE `id` > 40 AND `creation` <= 9959595 AND (SELECT COUNT(*) FROM `pla' at line 1