Re: MySQL Command to edit a single record

2002-12-21 Thread Jeffrey Ellis
n Sat, 2002-12-21 at 18:56, 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 en

Re: MySQL Command to edit a single record

2002-12-21 Thread Jeffrey Ellis
e > fields from 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-- >> >>

Re: MySQL Command to edit a single record

2002-12-21 Thread Jeffrey Ellis
you looking for an update table syntax? >> >> Example >> Update tablename >> Set FullName="Their Full Name" where someotherfield="someother value"; >> >> Careful with this one. As if you omit the where clause it will update >> every record!

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