navicatÔõôÓôúÂëɾ³ýÊý¾Ý
ÔÚ navicat ÖÐʹÓôúÂëɾ³ýÊý¾ÝÐèÒªÎå²½£º½¨ÉèÅþÁ¬²¢·¿ª±í¡£ÔÚ±à¼Æ÷´°¿ÚÖÐÊäÈë delete from where ¡£È·±£Ñ¡ÔñÁË׼ȷµÄ sql ±à¼Æ÷Ñ¡Ï¡£µ¥»÷¡°ÔËÐС±°´Å¥¡£È·ÈÑþ³Øý²Ù×÷¡£
ÔõÑùʹÓà Navicat ´úÂëɾ³ýÊý¾Ý
ÔÚ Navicat ÖÐʹÓôúÂëɾ³ýÊý¾Ýʱ£¬ÐèҪƾ֤ÒÔÏ°취²Ù×÷£º
µÚÒ»²½£º½¨ÉèÅþÁ¬
·¿ª Navicat£¬²¢ÅþÁ¬µ½ÒªÉ¾³ýÊý¾ÝµÄÊý¾Ý¿â¡£
µ¥»÷¡°¹¤¾ß¡±>¡°±í¡±£¬Ñ¡ÔñÄúÒª´ÓÖÐɾ³ýÊý¾ÝµÄ±í¡£
µÚ¶þ²½£ºÔÚ±à¼Æ÷Öз¿ª±í
ÔÚ±íÉÏÓÒ¼üµ¥»÷£¬È»ºóÑ¡Ôñ¡°±à¼Êý¾Ý¡±¡£
Õ⽫ÔÚÒ»¸öеıà¼Æ÷´°¿ÚÖз¿ª±í¡£
µÚÈý²½£º±àдɾ³ýÅÌÎÊ
ÔÚ±à¼Æ÷´°¿ÚÖУ¬µ¥»÷¡°SQL¡±Ñ¡Ï¡£
ÔÚ SQL ±à¼Æ÷ÖУ¬ÊäÈëÒÔÏ´úÂ룺
DELETE FROM WHERE
µÇ¼ºó¸´ÖÆ
ÆäÖУº
£ºÒª´ÓÖÐɾ³ýÊý¾ÝµÄ±íµÄÃû³Æ¡£
£ºÉ¾³ýÊý¾ÝµÄÌõ¼þ¡£´ËÌõ¼þ¿ÉÒÔ»ùÓÚ±íÖеÄÈκÎÁС£
µÚËIJ½£ºÔËÐÐÅÌÎÊ
È·±£Ñ¡ÔñÁË׼ȷµÄ SQL ±à¼Æ÷Ñ¡Ï¡£
µ¥»÷¡°ÔËÐС±°´Å¥£¨Í¨³£ÊÇÒ»¸öÂÌÉ«µÄÈý½ÇÐÎͼ±ê£©ÒÔÔËÐÐÅÌÎÊ¡£
µÚÎå²½£ºÈ·ÈÑþ³Øý
ϵͳ½«ÌáÐÑÄúÈ·ÈÑþ³Øý²Ù×÷¡£
µ¥»÷¡°ÊÇ¡±ÒÔÈ·Èϲ¢É¾³ýÊý¾Ý¡£
ʾÀý£º
Òª´ÓÃûΪ “Customers” µÄ±íÖÐɾ³ýËùÓÐÄêËêÁè¼Ý 60 ËêµÄ¿Í»§£¬¿ÉÒÔʹÓÃÒÔÏ´úÂ룺
DELETE FROM Customers WHERE Age > 60
µÇ¼ºó¸´ÖÆ
ÔËÐдËÅÌÎʽ«É¾³ýËùÓÐÖª×ãÌõ¼þµÄ¿Í»§Êý¾Ý¡£
ÒÔÉϾÍÊÇnavicatÔõôÓôúÂëɾ³ýÊý¾ÝµÄÏêϸÄÚÈÝ£¬¸ü¶àÇë¹Ø×¢±¾ÍøÄÚÆäËüÏà¹ØÎÄÕ£¡