Óû§Ãû£ºÄäÃûÓû§
update
±íÃû³Æ
set
ÁÐÃû³Æ
=
ÐÂÖµ
where
ÁÐÃû³Æ
=
ijֵ£¬updateÓï¾äµÄд·¨£º
1¡¢update
table_name
2Õ**É¡¢set
column1=value1,column2=value2,
3¡¢where
column(1)=value(1)¿×²èÇëÄÏ,column(2)=value(2)...and
column(n)=value(n);
4¡¢updatίºòϲe
person
set
address
=
'zhongshan
2ÌáÔò3',
city
=
'nanjing'£¬where
lastname
=
'wilson'
À©Õ¹**
sqlµÄupdateÓï¾äд·¨µÄÌصã
1¡¢¹ýÎóÉܵ׽ÓÒ»Ì廯£ºsql¼¯**¶¨Òåddl¡¢**²Ù×Ýd»¹mlºÍ**¿ØÖÆdclÓÚÒ»Ì壬¿ÉÒÔÍê³É**¿âÖеÄÈ«²¿¹¤×÷¡£
2¡¢Ê¹Ó÷½Ê½Áé»î£ºËü¾ßÓÐÁ½ÖÖʹÓ÷½Ê½£¬¼´¿ÉÒÔÖ±½ÓÒÔÃüÁʽ½»»¥Ê¹Óã»Ò²¿ÉÒÔǶÈëʹÓã¬Ç¶Èëµ½c¡¢c++¡¢fortran¡¢cobol¡¢j**aµÈÖ÷ÓïÑÔÖÐʹÓá£
3¡¢·ý³Ì»¯£ºÖ»Ìá²Ù×÷ÒªÇ󣬲»±ØÃèÊö²Ù×÷²½Ö裬±¨»³ÂÞʸ߰뻪ÑîÒ²Ò²²»ÐèÒªµ¼º½¡£Ê¹ÓÃʱֻÐèÒª¸æËßÇÐÖÚËɲɼÆËã»ú¡°×öʲô¡±£¬¶ø²»ÐèÒª¸æËßËü¡°Ôõô×ö¡±¡£
4¡¢ÓïÑÔ¼ò½à£¬Óï·¨¼òµ¥£¬ºÃѧºÃÓãºÔÚansi±êÊô×¼ÖУ¬Ö»°üº¬ÁË94¸öÓ¢ÄãÎĵ¥´Ê£¬ºËÐŦÄÜÖ»ÓÃ6¸ö¶¯´Ê£¬Óï·¨½Ó½üÓ¢Óï¿ÚÓï¡£
²Î¿¼**À´Ô´£º°Ù¶È°Ù¿Æ¡ªupdate
£¨**¿âsqlÓï·¨ÓÃÓ
