Dear all,
I am running Mysql on a Linux System ( Caos ).
Today when I am trying to create a procedure in it, I m facing the below
issue :
ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE
My OS version is :
Systemr-5:~ # cat /etc/issue
Welcome to SUSE Linux Enterprise Server 10 SP1
Am 02.01.2012 16:33, schrieb Biz-comm:
Thanks for any assistance.
Web page that needs a sort of all records with a specific state, set to
show, and if it exists in one of 4 categories.
Using this:
SELECT *
FROM listings
WHERE listing_state = 'DC'
AND listings.listing_show
Hi Patrice
I would try some brackets.
Something like this should work
SELECT * FROM listings WHERE listing_state = 'DC' AND listings.listing_show
='y' AND ( listings.cat1 = 23 OR listings.cat2 = 23 OR listings.cat3 =
23 )
Mike
- Original Message -
From: Biz-comm
Perfect. Thanks so much.
On Jan 2, 2012, at 10:40 AM, Mike OK wrote:
Hi Patrice
I would try some brackets.
Something like this should work
SELECT * FROM listings WHERE listing_state = 'DC' AND listings.listing_show
='y' AND ( listings.cat1 = 23 OR listings.cat2 = 23 OR
On 31 Dec 11, at 20:36, Govinda wrote:
If you're using MacOS X Server, it should be in /usr/bin, which should be in
your default $PATH, or else you couldn't do ANYTHING, including ls.
I have notes somewhere in my stuff about how to get $PATH to include where
mysql actually lives, but once