uery adds NAME and ADDRESS (where the last name is
>>>>> wrongly placed) and set ADDRESS to an empty string.
>>>>>
>>>>> UPDATE tablename SET FullName=CONCAT(FullName,Address),Address=''
>>>>> WHERE ID=
>>>>>
>>> Jeff,
> >>>>
> >>>> Are you looking for an update table syntax?
> >>>>
> >>>> Example
> >>>> Update tablename
> >>>> Set FullName="Their Full Name" where someotherfield="s
mple
>>>> 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!
>>>>
;> 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!
> >>
> >>
> >>
> >> -Original M
>>
>>
>>
>> -----Original Message-
>> From: Jeffrey Ellis [mailto:[EMAIL PROTECTED]]
>> Sent: Saturday, December 21, 2002 3:52 PM
>> To: [EMAIL PROTECTED]
>> Subject: MySQL Command to edit a single record
>>
>> Hi--
>>
>
Original Message-
> From: Jeffrey Ellis [mailto:[EMAIL PROTECTED]]
> Sent: Saturday, December 21, 2002 3:52 PM
> To: [EMAIL PROTECTED]
> Subject: MySQL Command to edit a single record
>
> Hi--
>
> I have just begun using MySQL...I am using a program called MySQL to
> m
Ellis [mailto:[EMAIL PROTECTED]]
Sent: Saturday, December 21, 2002 3:52 PM
To: [EMAIL PROTECTED]
Subject: MySQL Command to edit a single record
Hi--
I have just begun using MySQL...I am using a program called MySQL to
manage
an online database. I can see the entire table I need and all the
recor
Hi--
I have just begun using MySQL...I am using a program called MySQL to manage
an online database. I can see the entire table I need and all the records in
that table for the db I¹m working with. I have a field called fullname which
is supposed to receive the full name of the person entering the
