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
