Currently viewing the category: "letsgetnuts.com"

Can you use a stored procedure in a subquery? I don’t think so. (MySQL)

By On September 27, 2006 · 14 Comments

I do not think you can use the result of a stored procedure in an ad-hoc subquery.

On my social network, LetsGetNuts.com, I have a Friend table. This is the structure:

mysql> describe Friend;
+—————-+—————+——+—–+———+——-+
| Field | Type | Null | Key | Default | Extra |
+—————-+—————+——+—–+———+——-+
[...]

Continue Reading →