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.:( 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) > Hi, > > What am i doing wrong: > > # ./mysql <database name> -e "delete * from <table name> where id > 5;" > > I get the mysql help page on exectuting the above command. > > The mysql verison i am using is : 3.23.52. > > Thanks and regards > anil. > > --------------------------------------------------------------------- > 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 > > > > > > --------------------------------------------------------------------- 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