MySQL Command to edit a single record

2002-12-21 Thread Jeffrey Ellis
. Is there a way to do this? All My Best, Jeffrey Ellis

Re: MySQL Command to edit a single record

2002-12-21 Thread Jeffrey Ellis
=Their Full Name where someotherfield=someother value; Careful with this one. As if you omit the where clause it will update every record! -Original Message- From: Jeffrey Ellis [mailto:[EMAIL PROTECTED]] Sent: Saturday, December 21, 2002 3:52 PM To: [EMAIL PROTECTED] Subject

Re: MySQL Command to edit a single record

2002-12-21 Thread Jeffrey Ellis
the original table plus an ID field, auto_numeric, and insert the registers from the old table to the new one. Then, use the UPDATE on the new table. Adolfo On Sat, 2002-12-21 at 17:35, Jeffrey Ellis wrote: Hi, Adolfo-- Thank you! But I have two problems here...First, I (whoops!) don't have

Re: MySQL Command to edit a single record

2002-12-21 Thread Jeffrey Ellis
, Jeffrey Ellis wrote: Hi, Adolfo-- Thank you again! However, the problem is, the table is linked to a file on the web. If I create a new table with a different name the link wont work and no data will be entered. Is there a way to rename a table once you create it? Then, I could delete