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
RE: command line exectution of query(newbie)
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
RE: command line exectution of query(newbie)
Database name goes after options. It is showing you the help page because it does not understand what you are passing to it. It's kind of saying Here, look at this, this is how I work, follow these directions they might help you out. -Original Message- From: Anil Garg [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 10:26 AM To: [EMAIL PROTECTED] 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
RE: command line exectution of query(newbie)
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:[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
RE: command line exectution of query(newbie)
thanks, that helped :) -Original Message- From: Jennifer Goodie [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 1:49 PM To: Anil Garg; [EMAIL PROTECTED] Subject: RE: command line exectution of query(newbie) Database name goes after options. It is showing you the help page because it does not understand what you are passing to it. It's kind of saying Here, look at this, this is how I work, follow these directions they might help you out. -Original Message- From: Anil Garg [mailto:[EMAIL PROTECTED] Sent: Thursday, March 06, 2003 10:26 AM To: [EMAIL PROTECTED] 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