#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 'select pagelink from test LIMIT 0, 30' at line 1
still not working phpmyadmin goes on loading forever and nothing happens..i used your query directly in phpmyadmin .simple query are working like getting distinct etc......what can be wrong?except,not in,exists nothing works
select type for crawlerebook and test is simple
type for both is all
possible_keys for both is null
key for both is null
key_len for both is null
ref for both is null
in extra column crawlerebook shows nothing(blank)
and test says using where;not exists
You somehow made it very difficult by not copying the actual structure of the explain..
Anyway, you should add indexes on 'links' in the crawled table and on 'pagelink' in the test table.
<?php
include("config.php");
$sql = "explain SELECT `links` FROM `crawlerebook` LEFT JOIN `test` ON `crawlerebook`.`links`=`test`.`pagelink` WHERE `test`.`pagelink` IS NULL";
echo mysql_query($sql);
?>