title: Can I have a condition for truncate table query in mysql latest version?
body: <p>My requirement is to have a condition for the <code>truncate</code> query in <code>MySQL</code> since I want only to empty half of the table. I know I can use <code>delete from</code> table query. but the problem is. If I <code>delete</code>, the table contents the primary key (auto_increment) will continue from the id where it was before deleted. But truncate makes it start from the beginning. </p>
  
  <p>If the answer is yes please tell me how, If No, can I know the alternative way?</p>
  
  <p>Thanks in advance.</p>