Cannot created stored procedure (Using example from mysql manual) -- mysql 5.1.37 -- Ubuntu 9.10

2009-12-16 Thread Walton Hoops
Hi all. I am running into a very frustrating problem trying to created a stored procedure. I had originally assumed I was using bad syntax, but even examples copied and pasted directly from the manual are giving the same error. mysql CREATE DEFINER = 'walton'@'localhost' PROCEDURE

RE: Cannot created stored procedure (Using example from mysql manual) -- mysql 5.1.37 -- Ubuntu 9.10

2009-12-16 Thread Walton Hoops
-Original Message- From: Walton Hoops [mailto:wal...@vyper.hopto.org] Hi all. I am running into a very frustrating problem trying to created a stored procedure. I had originally assumed I was using bad syntax, but even examples copied and pasted directly from the manual

RE: Why doesn't mySQL stop a query when the browser tab is closedL

2009-07-26 Thread Walton Hoops
Even if it did, it would be by convention only, there is no guarantee. Not only that, but it would likewise be dependent on the browser closing normally, which is likewise no guarantee. The fact of the matter here however is that there is NO set of behavior that would suit everyone. I can

Lock timeouts

2009-07-09 Thread Walton Hoops
Oh wise and all knowing MySQL Guru's: I've been running into a problem recently that has be confused. I have 2 tables, both with the structure: DROP TABLE IF EXISTS `acn_market_level`.`market_scans`; CREATE TABLE `acn_market_level`.`market_scans` ( `Retailer` char(3) NOT NULL, `Marketkey`

FW: Lock timeouts

2009-07-09 Thread Walton Hoops
Forwarded response from Micheal. I haven't tested it yet (have to wait till I have more data to move), but this sounds about right. Thanks! -Original Message- From: Michael Dykman [mailto:mdyk...@gmail.com] Sent: Thursday, July 09, 2009 1:22 PM To: Walton Hoops Subject: Re: Lock