mysqli truncate

[12strings]

I need to remove all records in a table and set the id to 1. can't figure out how? Thanks in advance.
After 5 minutes, no action, no error message, no chg to table.
I'm running PHP version 5.4.4

Code: Select all

<?php
$db = new mysqli("localhost","root","cookie","homedb");
if($db->query("ALTER TABLE calculator AUTO_INCREMENT = 1") == false) {
$db->rollback();
  throw new Exception("autoincrement reset failed: ".$db->error);
 }
$db->commit();
?> 

[Nobbie]

Simple run a "Drop Table" and create a new table after. Truncate does not reset the primary key.