GoFuckYourself.com - Adult Webmaster Forum - View Single Post - MySQL question regarding truncating tables.

Angry Jew Cat - Banned for Life · 01-13-2011, 09:33 AM

Can you Truncate a table with a WHERE clause, and remove only elements which match a certain criteria? Or is TRUNCATE simply used to wipe the entire table?

01-13-2011, 09:33 AM
Angry Jew Cat - Banned for Life (felis madjewicus) Industry Role: Join Date: Jul 2006 Location: In Mom & Dad's Basement Posts: 20,368	MySQL question regarding truncating tables. Can you Truncate a table with a WHERE clause, and remove only elements which match a certain criteria? Or is TRUNCATE simply used to wipe the entire table?