7 messages in com.mysql.lists.mysqlRE: replace qeustion
FromSent OnAttachments
soon chee keong21 Mar 2001 06:59 
soon chee keong21 Mar 2001 06:59 
Mike<mickalo>Blezien21 Mar 2001 10:22 
Cal Evans21 Mar 2001 10:23 
Oson, Chris M.21 Mar 2001 10:34 
Gerald L. Clark21 Mar 2001 10:44 
Bill Marrs21 Mar 2001 12:35 
Subject:RE: replace qeustion
From:Oson, Chris M. (CHRI@saic.com)
Date:03/21/2001 10:34:47 AM
List:com.mysql.lists.mysql

UPDATE Table_1 SET C = 20 WHERE A = 10 AND B = 18

you might want to read a basic SQL book before asking this type of question....

HTH,

christopher oson

-----Original Message----- From: soon chee keong [mailto:ckso@hotmail.com] Sent: Wednesday, March 21, 2001 6:59 AM To: mys@lists.mysql.com Subject: replace qeustion

Table_1

------------------------- A B C

------------------------- 10 18 9 4 3 1

--------------------------

how can i change column C's "9" to say "20" without inserting a new record and columns A and B remain unchanged?

do i use REPLACE or what?please advice.

_________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

--------------------------------------------------------------------- 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 <mysq@lists.mysql.com> To unsubscribe, e-mail <mysql-unsubscribe-CHRIS.M.OSON=saic@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php