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:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 2:38 PM To: Anil Garg; [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, March 06, 2003 6:26 PM Subject: command line exectution of query(newbie)
sql, query
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
