|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Codewalkers Forums Sponsor:
|
 AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th-1:00PM EST. Register Today!
|
|
#1
January 15th, 2003, 02:52 AM
|
|||
|
|||
|
Set Options???
In MySQL:
When using this code: ( SELECT t1.oid, MAX(t2.score) + MAX(t1.score) + MAX(t3.score) + MAX(t4.score) + MAX(t5.score) + MAX(t6.score) as score FROM whitetailtypical t1, whitetailnontypical t2, blacktailnontypical t3, blacktailtypical t4, mulenontypical t5, muletypical t6 WHERE t1.name=t2.name GROUP BY t1.name ORDER BY score DESC; ) it tells me to use the code SET OPTION SQL_BIG_SELECTS=1. Where would I put it in the code at?
|
|
#3
January 15th, 2003, 12:35 PM
|
|||
|
|||
|
RE: Set Options???
Like just put it in the PHP code in a different query on the same page?
|
|
#4
January 15th, 2003, 12:36 PM
|
|||
|
|||
|
RE: Set Options???
or like this?
SET OPTION SQL_BIG_SELECTS=1; SELECT t1.oid, MAX(t2.score) + MAX(t1.score) + MAX(t3.score) + MAX(t4.score) + MAX(t5.score) + MAX(t6.score) as score FROM whitetailtypical t1, whitetailnontypical t2, blacktailnontypical t3, blacktailtypical t4, mulenontypical t5, muletypical t6 WHERE t1.name=t2.name GROUP BY t1.name ORDER BY score DESC;
|
|
#5
January 18th, 2003, 01:10 PM
|
|||
|
|||
|
RE: Set Options???
?
 :
|
|
| Viewing: Codewalkers Forums > Other Technologies > Database Help > Set Options??? |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
