Hi,
Got this problem and setting the SQL_BIG_SELECTS=1 is not an option. Is
there a way to change the WHERE so the query would work?
Error
SQL-query :
SELECT distinct(fincodedesc),
industry.code,
industry.level1,
industry.level2,
industry.level3,
industry.level4,
industry.level5
FROM industry,branchinfo WHERE
branchinfo.code1=industry.code OR
branchinfo.code2=industry.code OR
branchinfo.code3=industry.code OR
branchinfo.code4=industry.code OR
branchinfo.code5=industry.code
ORDER by industry.code ASC LIMIT 0, 30
MySQL said:
The SELECT would examine too many records and probably take a very long
time. Check your WHERE and use SET OPTION SQL_BIG_SELECTS=1 if the SELECT is ok
TABLE SCHEMA's
CREATE TABLE industry (
kid int(11) NOT NULL auto_increment,
code varchar(8) NOT NULL default '',
svecodedesc text NOT NULL,
fincodedesc text NOT NULL,
level1 varchar(8) NOT NULL default '',
level2 varchar(8) NOT NULL default '',
level3 varchar(8) NOT NULL default '',
level4 varchar(8) NOT NULL default '',
level5 varchar(8) NOT NULL default '',
industry_modified timestamp(14) NOT NULL,
PRIMARY KEY (kid),
UNIQUE KEY kid (kid),
KEY kid_2 (kid,code,level1,level2,level3,level4,level5),
FULLTEXT KEY svecodedesc (svecodedesc,fincodedesc)
) TYPE=MyISAM;
CREATE TABLE branchinfo (
did int(10) unsigned NOT NULL auto_increment,
aid int(10) unsigned default NULL,
svebranch text,
finbranch text,
engbranch text,
gerbranch text,
code1 varchar(8) default '0',
code2 varchar(8) default '0',
code3 varchar(8) default '0',
code4 varchar(8) default '0',
code5 varchar(8) default '0',
branchinfo_modified timestamp(14) NOT NULL,
PRIMARY KEY (did),
UNIQUE KEY did (did,aid),
KEY did_2 (did,code1,code2,code3,code4,code5,aid),
FULLTEXT KEY branchinfo_search (svebranch,finbranch,engbranch,gerbranch)
) TYPE=MyISAM;
jari Mäkelä
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
