On Wed, 21 Mar 2001 14:59:38 -0000, "soon chee keong" <[EMAIL PROTECTED]>
wrote:
A very basic UPDATE will do the trick.
UPDATE Table_1 SET
C = '20'
WHERE C = '9'
>>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.
>>
>>chee keong
>>_________________________________________________________________________
>>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 <[EMAIL PROTECTED]>
>>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
Mike(mickalo)Blezien
========================================
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225) 686-2002
=========================================
---------------------------------------------------------------------
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
