Hi, Adolfo-- Thank you!
But I have two problems here...First, I (whoops!) don't have an id field. In the program I use, you can only set a key field when you first create the database. I would love to have an id field, but don't know how to create one now. :( The second is that the command will -- I think -- place the last name right up against the first name with no space before. Is there a way to do that so it looks like "Foo Bar"? All My Best, Jeffrey on 12/21/02 1:23 PM, Adolfo Bello at [EMAIL PROTECTED] wrote: > The following query 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=<the register id> > > Adolfo > > On Sat, 2002-12-21 at 17:07, Jim Hankins wrote: >> Jeff, >> >> Are 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! >> >> >> >> -----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 >> 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 >> information. >> But sometimes, folks are entering their first name only in this field >> and >> then entering their last name in the address field by mistake. I would >> like >> to be able to send a command to the database to be able manually edit >> those >> records to add the last name back into the fullname field. >> >> Is there a way to do this? >> >> All My Best, >> Jeffrey Ellis >> >> >> >> >> >> --------------------------------------------------------------------- >> 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
