Re: registerDriver()
Posted by: Mark Matthews
Date: May 10, 2005 02:22PM

Sean Breslin wrote:
> Oh...
>
> So the only way to get this to work would be to
> install an actual MySQL database on my own
> computer... Or if my partner gets Sybase
> working...
>
> Thanks a lot for your help. I learned a lot about
> how databases programming actually works the past
> few days.
>
> I do, however, have one last question... When
> creating and testing queries, a few of our queries
> were rejected entirely and I'm curious as to why.
> They all have SELECT nested inside a WHERE, which
> the professor said is correct for SQL. Here's an
> example:
>
> SELECT Id
> FROM Item
> WHERE Type = (
> SELECT Type
> FROM Item
> WHERE (Id =
> SELECT ID
> FROM Purchased
> WHERE (BuyerUN = ?)
> )
> )
>
> (? would be replaced with a variable)
> The above should display all item's IDs that have
> the same Type.


MySQL doesn't support subqueries unless you use MySQL-4.1.x or newer.

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html

Options: ReplyQuote


Subject
Written By
Posted
May 09, 2005 07:17PM
May 09, 2005 07:43PM
May 09, 2005 07:56PM
May 09, 2005 08:07PM
May 09, 2005 08:51PM
May 09, 2005 09:04PM
May 10, 2005 11:17AM
May 10, 2005 12:34PM
May 10, 2005 12:59PM
May 10, 2005 01:19PM
May 10, 2005 01:30PM
May 10, 2005 01:44PM
May 10, 2005 01:52PM
May 10, 2005 02:05PM
Re: registerDriver()
May 10, 2005 02:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.