> You SELECT statrment
> SELECT
> (s.server_disk_space * s.server_load * s.server_ram),
> s.server_fqdn,
> s.server_url,
> s.server_id
> INTO
> L_server_load,
> L_server_fqdn,
> L_server_url,
> L_server_id
> FROM clientdev.servers s
> WHERE s.active = 1
>
TECTED]>
To: mysql@lists.mysql.com
Sent: Thursday, March 1, 2007 9:49:10 PM (GMT-0500) Auto-Detected
Subject: Stored process accessing tables in different database
I'm having trouble with a stored proc. The problem is that the first
table is in a different database. Here is the test store
I'm having trouble with a stored proc. The problem is that the first
table is in a different database. Here is the test stored proc below.
Where I run this I get " ERROR 1327 (42000): Undeclared variable: s". I
have tried it by declaring "clientdev.servers s" and just by using
"clientdev.server
