-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
On Fri, 23 Sep 2005, Jasper Bryant-Greene wrote:
> Thing is, even though I get that error, the server keeps running and
> accepting other connections and responding to queries fine.
Probably because the mysqld_safe wrapper script has restarted i
On Thursday, 22 September 2005 at 17:06:32 +1200, Jasper Bryant-Greene wrote:
> Jasper Bryant-Greene wrote:
>> I have a stored procedure defined as follows:
>>
>> ...
>>
>> Sometimes when I execute this stored procedure ... I get the error
>> "Lost connection to MySQL server during query".
>>
>> I
Greg 'groggy' Lehey wrote:
On Thursday, 22 September 2005 at 17:06:32 +1200, Jasper Bryant-Greene wrote:
Jasper Bryant-Greene wrote:
Sometimes when I execute this stored procedure ... I get the error
"Lost connection to MySQL server during query".
I am using MySQL 5.0.12-beta-log on Gentoo
Jasper Bryant-Greene wrote:
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;
Sometimes when I execute this stored procedure with, for examp
Daniel wrote:
What API are you using to call the SP from--PHP mysqli, Perl DBD-mysql,
etc.?
PHP MySQLi
Jasper Bryant-Greene wrote:
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKE
What API are you using to call the SP from--PHP mysqli, Perl DBD-mysql,
etc.?
-Daniel
Jasper Bryant-Greene wrote:
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM user
Hi,
2005/9/21, Jasper Bryant-Greene <[EMAIL PROTECTED]>:
> Martijn Tonies wrote:
> >
> >>I have a stored procedure defined as follows:
> >>
> >>CREATE PROCEDURE `album`.`getUser`( IN userID INT )
> >> READS SQL DATA
> >> DETERMINISTIC
> >> SQL SECURITY INVOKER
> >>SELECT * FROM users
Martijn Tonies wrote:
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;
Sometimes when I execute this stored procedure with, for example:
> I have a stored procedure defined as follows:
>
> CREATE PROCEDURE `album`.`getUser`( IN userID INT )
> READS SQL DATA
> DETERMINISTIC
> SQL SECURITY INVOKER
> SELECT * FROM users WHERE id=userID LIMIT 1;
>
> Sometimes when I execute this stored procedure with, for example:
>
> C
I have a stored procedure defined as follows:
CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;
Sometimes when I execute this stored procedure with, for example:
CALL getUser(7);
I get
10 matches
Mail list logo
