±¾È˲ËÄñ Çó¾È²ËÄñÎÊÌâ ¹ØÓÚsqlÓï¾ä£¡£¡
¿´±ðÈ˵ijÌÐò
²éÕÒÊÇselect * from house where XX = YY and...
ɾ³ýÊÇdelete * from house where XX = YY and...
ÄÇôÏëÒªÐÞ¸ÄÔÏȵÄÊý¾ÝÔõô°ì£¿
lzÕÒһЩ»ù±¾µÄSQLµÄ×ÊÁÏ¿´¿´°É
ºÙºÙ£¬»¹Êǵÿ´¿´Ê飬ÊìϤһϵıȽϺá£
update table set column = value where aa = bb;
SQL code:
update house set xx=aa where XX = YY and...
1.²éѯ select
2.ɾ³ý delete
3.¸üРupdate
ÕâÖÖÎÊÌâ×îºÃÏÈËÑË÷Ò»ÏÂ,½â¾ö²»ÁËÔÙÌáÎÊ
Update house set XX=EE where XX=YY
ÈçÐèÒªÔĶÁ¸Ã»Ø¸´£¬ÇëµÇ¼»ò×¢²áCSDN!
Ïà¹ØÎÊ´ð£º
½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿
21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......
»·¾³£º1.win2003server+oracle9i
2.oracle9i×Ö·û¼¯ÎªAMERICAN_AMERICA.WE8ISO8859P1
3.oracle sql developer°æ±¾ 1.5.5
ÏÖÏóÃèÊö: 1.ÔÚsql developer ÖвéѯoracleÖеÄij¸ö±í£¬ÖÐÎÄÈ«²¿ÏÔʾΪÂÒÂë¡£
......
access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôÔÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ
sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£
ÊÇ ......