mysql doubt

[Anon]

does mysql supports subqueries?

[[deleted]]

No.

[amcgrath]

OK, I am not an mysql expert and after reading this post I thank God I never used it. No sub queries? Jeesh, why does anybody use MySQL?

[[deleted]]

"why does anybody use MySQL?"

Because
a) it's free
b) it's small
c) it's easy to use

and

d) because sub-queries are usefull but VERY VERY expensive. A join is often faster and more economical.

It's the lack of referential integrety and functional-indexing that really makes it a shitty database.