Re: why does basic MySQLdump on db table fail with "Permission denied", or else it creates a zero KB file

2012-01-02 Thread Jan Steinman
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,

Re: Beginner question

2012-01-02 Thread 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 listi

Re: Beginner question

2012-01-02 Thread Mike OK
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" To: Sent:

Re: Beginner question

2012-01-02 Thread Reindl Harald
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.lis

ERROR 1307 (HY000) at line 31: Failed to CREATE PROCEDURE

2012-01-02 Thread Adarsh Sharma
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 (x