MySQL为æ们æä¾äºdeleteåtruncateè¯å¥æ¥å é¤æ°æ®ã
delete è¯å¥çå®ä¹ï¼
å é¤æ°æ®çæ¶åç¨ç大å¤é½æ¯ delete è¯å¥ãç°å¨è®©æ们æ¥çä¸ä¸ deleteè¯å¥çå®ä¹ã
DELETE [LOW_PRIORITY] [QUICK] [IGNORE] FROM tbl_name
[WHERE where_definition]
[ORDER BY ...]
[LIMIT row_count]
delete 注æäºé¡¹ï¼
ä»è¯æ³ç»æä¸ï¼æ们就å¯ä»¥çåºï¼å update è¯æ³ä¸æ ·ï¼æ们æ¯å¯ä»¥çç¥ where åå¥çãä¸è¿è¿æ¯ä¸ä¸ªå¾å±é©çè¡ä¸ºãå 为å¦æä¸æå® where åå¥ï¼delete å°å é¤è¡¨ä¸ææçè®°å½ï¼èä¸æ¯ç«å³å é¤.
truncate è¯å¥çç®å说æï¼
è¿ä¸ªè¯å¥ä¹åæä¹æ²¡ææ¥è§¦è¿ï¼ä¹æ²¡æ使ç¨è¿ãå 为ä¸è¬æ åµä¸ï¼å é¤æ°æ®å¤§å®¶é½å¨ä½¿ç¨deleteè¯å¥ãå ¶å®è¿ä¸ªtruncate å½ä»¤å¾ç®åï¼å®çæææ¯ï¼å é¤è¡¨çææè®°å½ãç¸å½äº delete è¯å¥ä¸å where åå¥ä¸æ ·ãå ¶è¯æ³ç»æ为ï¼
TRUNCATE [TABLE] tbl_name
è¿éç®åçç»åºä¸ªç¤ºä¾ï¼ææ³å é¤ friends 表ä¸ææçè®°å½ï¼å¯ä»¥ä½¿ç¨å¦ä¸è¯å¥ï¼
truncate table friends;
truncate å deleteçæçé®é¢ï¼
å¦ææ³è¦å é¤è¡¨çæææ°æ®ï¼truncateè¯å¥è¦æ¯ delete è¯å¥å¿«ãå 为 truncate å é¤äºè¡¨ï¼ç¶åæ ¹æ®è¡¨ç»æéæ°å»ºç«å®ï¼è delete å é¤çæ¯è®°å½ï¼å¹¶æ²¡æå°è¯å»ä¿®æ¹è¡¨ãè¿ä¹æ¯ä¸ºä»ä¹å½åä¸ä¸ªä½¿ç¨ delete æ¸ ç©ºç表æå ¥æ°æ®æ¶ï¼MySQL ä¼è®°ä½åé¢äº§ççAUTOINCREMENTåºåï¼å¹¶ä¸ç»§ç»å©ç¨å®å¯¹AUTOINCREMENTå段ç¼å·ãètruncateå é¤è¡¨åï¼è¡¨æ¯ä»1å¼å§ä¸ºautoincrementå段ç¼å·ã
ä¸è¿truncateå½ä»¤å¿«è§å¿«ï¼å´ä¸ådeleteå½ä»¤é£æ ·å¯¹äºå¡å¤çæ¯å®å ¨çãå æ¤ï¼å¦ææ们æ³è¦æ§è¡truncateå é¤ç表æ£å¨è¿è¡äºå¡å¤çï¼è¿ä¸ªå½ä»¤å°±ä¼äº§çéåºå¹¶äº§çé误信æ¯ã
需要在php页面执行。。。
追答哎,在页面执行用mysql_query