Comment 7 for bug 1515929

Revision history for this message
Ed Cooper (ed-cooper) wrote :

Thanks for the update.

I've tried running the delete statement:

DELETE FROM `usr_custom_layout` WHERE `id` NOT IN ( SELECT MIN(`id`) FROM `usr_custom_layout` GROUP BY `usr`, `group`, `institution`, `layout`);

But it results in:

ERROR 1093 (HY000): You can't specify target table 'usr_custom_layout' for update in FROM clause