Re: Edit a MySQL Record

2002-02-03 Thread DL Neil
Nick, > How would I go about editing a certain record in a > MySQL database; Items? I want to be able to change a > value that was already inserted into the table. You neglected to mention which tool(s) you have at your disposal. SELECT the pertinent row. View the data. Amend it as required. U

Re: Edit a MySQL Record

2002-02-03 Thread Fredrick Bartlett
Here you go... update MyDB set FIRST_NAME = "JOE", LAST_NAME = "BLO" where RECNO = "" - Original Message - From: "Nick McBride" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, February 03, 2002 8:58 AM Subject: Edit a MySQL Record > How would I go about editing a certain r

Re: Edit a MySQL Record

2002-02-03 Thread Doug Thompson
This topic is covered quite well in the manual. http://www.mysql.com/doc/U/P/UPDATE.html On Sun, 3 Feb 2002 08:58:33 -0800 (PST), Nick McBride wrote: >How would I go about editing a certain record in a >MySQL database; Items? I want to be able to change a >value that was already inserted into