Re: Convert query from v4 syntax to v3
On 7 Jan 2004 at 11:04, Odhiambo Washington wrote: Hello, I have a query that executes well when run on MySQL-4.x, but not 3.23.x: SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain USING (domain_name) I would like to make this query run on a 3.23.58 server. I have tried SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain ON popbox.domain_name=domain.domain_name ..but I still end up with error. Of course I am lost about the syntax now ;) Basically, the problem begings with the USING... -Wash -- +== + |\ _,,,---,,_ | Odhiambo Washington[EMAIL PROTECTED] Zzz /,`.-'`'-. ;-;;,_ | Wananchi Online Ltd. www.wananchi.com |,4- ) )-,_. ,\ ( `'-'| Tel: +254 20 313985-9 +254 20 313922 '---''(_/--' `-'\_) | GSM: +254 722 743223 +254 733 744121 +== + Whatever the missing mass of the universe is, I hope it's not cockroaches! -- Mom Hi Wash Can you post the error message? Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Convert query from v4 syntax to v3
* Rory McKinley [EMAIL PROTECTED] [20040109 13:21]: wrote: On 7 Jan 2004 at 11:04, Odhiambo Washington wrote: Hello, I have a query that executes well when run on MySQL-4.x, but not 3.23.x: SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain USING (domain_name) I would like to make this query run on a 3.23.58 server. I have tried SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain ON popbox.domain_name=domain.domain_name ..but I still end up with error. Of course I am lost about the syntax now ;) Basically, the problem begings with the USING... [snip] Hi Wash Can you post the error message? The line is part of a small script. The error is: You have an error in your SQL syntax near 'USING (domain_name)' Best regards, Odhiambo Washington Wananchi Online Ltd. PS::REQUEST A: Because it reverses the logical flow of conversation. Q: Why is top posting frowned upon? http://learn.to/edit_messages http://www.netmeister.org/news/learn2quote.html --+- Odhiambo W. wash(at)wananchi(dot)com . WANANCHI ONLINE LTD (Nairobi, KE) http://www.wananchi.com/email/ . 1ere Etage, Loita Hse, Loita St., Mobile: (+254) 722 743 223 . # 10286, 00100 NAIROBI --+- What the hell, go ahead and put all your eggs in one basket. Pride goes before destruction, a haughty spirit before a fall. Proverbs 16:18 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Convert query from v4 syntax to v3
On 9 Jan 2004 at 16:48, Odhiambo Washington wrote: * Rory McKinley [EMAIL PROTECTED] [20040109 13:21]: wrote: On 7 Jan 2004 at 11:04, Odhiambo Washington wrote: Hello, I have a query that executes well when run on MySQL-4.x, but not 3.23.x: SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain USING (domain_name) I would like to make this query run on a 3.23.58 server. I have tried SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain ON popbox.domain_name=domain.domain_name ..but I still end up with error. Of course I am lost about the syntax now ;) Basically, the problem begings with the USING... [snip] Hi Wash Can you post the error message? The line is part of a small script. The error is: You have an error in your SQL syntax near 'USING (domain_name)' Hi Wash I can't see what is throwing the syntax error..p'raps I am just being dense. Try this query and see if it still throws the same error: SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox, domain WHERE popbox.domain_name = domain.domain_name Regards Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown)
Re: Convert query from v4 syntax to v3
* Rory McKinley [...] * Odhiambo Washington I have a query that executes well when run on MySQL-4.x, but not 3.23.x: [...] I can't see what is throwing the syntax error..p'raps I am just being dense. Note that INNER JOIN syntax allows a join_condition only from MySQL 3.23.17 on. The same is true for JOIN and CROSS JOIN only as of MySQL 4.0.11. URL: http://www.mysql.com/doc/en/JOIN.html Try this query and see if it still throws the same error: SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox, domain WHERE popbox.domain_name = domain.domain_name That should do it. :) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Convert query from v4 syntax to v3
On 9 Jan 2004 at 15:33, Roger Baklund wrote: * Rory McKinley [...] * Odhiambo Washington I have a query that executes well when run on MySQL-4.x, but not 3.23.x: [...] I can't see what is throwing the syntax error..p'raps I am just being dense. Note that INNER JOIN syntax allows a join_condition only from MySQL 3.23.17 on. The same is true for JOIN and CROSS JOIN only as of MySQL 4.0.11. URL: http://www.mysql.com/doc/en/JOIN.html Try this query and see if it still throws the same error: SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox, domain WHERE popbox.domain_name = domain.domain_name That should do it. :) -- Roger Oh well of course..if you're actually going to refer to the fine manual instead of blundering around in the dark...then you will get an answer a lot more quicklybut is it as much fun ? :) Sometimes I am just too dense for words... Rory McKinley Nebula Solutions +27 82 857 2391 [EMAIL PROTECTED] There are 10 kinds of people in this world, those who understand binary and those who don't (Unknown) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Convert query from v4 syntax to v3
Hello, I have a query that executes well when run on MySQL-4.x, but not 3.23.x: SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain USING (domain_name) I would like to make this query run on a 3.23.58 server. I have tried SELECT popbox.local_part, popbox.password_hash, popbox.domain_name, CONCAT(domain.path,'/',popbox.mbox_name) AS path FROM popbox JOIN domain ON popbox.domain_name=domain.domain_name ..but I still end up with error. Of course I am lost about the syntax now ;) Basically, the problem begings with the USING... -Wash -- +==+ |\ _,,,---,,_ | Odhiambo Washington[EMAIL PROTECTED] Zzz /,`.-'`'-. ;-;;,_ | Wananchi Online Ltd. www.wananchi.com |,4- ) )-,_. ,\ ( `'-'| Tel: +254 20 313985-9 +254 20 313922 '---''(_/--' `-'\_) | GSM: +254 722 743223 +254 733 744121 +==+ Whatever the missing mass of the universe is, I hope it's not cockroaches! -- Mom smime.p7s Description: S/MIME cryptographic signature
