At 13:40 -0500 3/6/03, Anil Garg wrote:
>Sorry,
>
># ./mysql <database name> -e "delete from <table name> where id > 5;"
>
>The above command too doesn't work, it shows the mysql man page.:(
My quess:
It's not showing the man page, it's showing an error message, followed
by the mysql help message. The help message is so long that you
probably didn't notice the error message at the beginning.
>
>any more ideas?
>
>thanks and regards
>anil.
>
>-----Original Message-----
>From: Jocelyn Fournier [mailto:joce@stripped]
>Sent: Thursday, March 06, 2003 2:38 PM
>To: Anil Garg; mysql@stripped
>Subject: Re: command line exectution of query(newbie)
>
>
>Hi,
>
>The right DELETE syntax is :
>
>delete from <table name> where id > 5;
>
>Regards,
> Jocelyn
>----- Original Message -----
>From: "Anil Garg" <anilg@stripped>
>To: <mysql@stripped>
>Sent: Thursday, March 06, 2003 6:26 PM
>Subject: command line exectution of query(newbie)
sql, query