Удаление данных из mysql таблицы

<?php
$connection = new mysqli("localhost","root","",'mybase');
$query = "delete from auto where id=2";
$result = $connection->query($query);
$query = "select * from auto";
$result = $connection->query($query);
while($row = mysqli_fetch_array($result))
{
echo "id ".$row ['id']."<br>";
}
?>

Результат:

id 1
id 3
id 4
id 5

<?php
$connection = new mysqli("localhost","root","",'mybase');
$query = "truncate table auto";
$result = $connection->query($query);
?>