Hi,
I'm new to MySQL and I'm trying to make a command which will check database integrit(dead links, when a table is linked to another table which was deleted...)
Code:
DELETE FROM `characters` LEFT JOIN `accounts` ON `characters`.`acct`=`accounts`.`acct` WHERE `accounts`.`acct`=NULL
Do you know where can be a problem ?
http://forums.databasejournal.com/clear.gif
http://forums.databasejournal.com/clear.gif
http://forums.databasejournal.com/clear.gif
http://forums.databasejournal.com/clear.gif
http://forums.databasejournal.com/clear.gif
Sorry for my English I'm czech...