ããæ°æ®éè¾å¤§æ²¡æå¿«éçæ¹æ³ï¼é¤éæ¯æ¸ 空表ï¼å¯ç¨truncateçæ¹å¼æ¥å é¤ã
ããå¦ï¼è¦å é¤è¡¨å为testä¸çæææ°æ®ï¼å¯ç¨ï¼
truncate table test;ããtruncateä¸deleteçå¼åï¼
ããTRUNCATE TABLE å¨åè½ä¸ä¸ä¸å¸¦ WHERE åå¥ç DELETE è¯å¥ç¸åï¼äºè åå é¤è¡¨ä¸çå ¨é¨è¡ãä½ TRUNCATE TABLE æ¯ DELETE é度快ï¼ä¸ä½¿ç¨çç³»ç»åäºå¡æ¥å¿èµæºå°ã
ããDELETE è¯å¥æ¯æ¬¡å é¤ä¸è¡ï¼å¹¶å¨äºå¡æ¥å¿ä¸ä¸ºæå é¤çæ¯è¡è®°å½ä¸é¡¹ãTRUNCATE TABLE éè¿éæ¾åå¨è¡¨æ°æ®æç¨çæ°æ®é¡µæ¥å é¤æ°æ®ï¼å¹¶ä¸åªå¨äºå¡æ¥å¿ä¸è®°å½é¡µçéæ¾ã
ããTRUNCATE TABLE å é¤è¡¨ä¸çææè¡ï¼ä½è¡¨ç»æåå ¶åã约æãç´¢å¼çä¿æä¸åãæ°è¡æ è¯æç¨ç计æ°å¼é置为该åçç§åãå¦ææ³ä¿çæ è¯è®¡æ°å¼ï¼è¯·æ¹ç¨ DELETEã