Reset Primary Key of a table

reset_pk.sql

ALTER TABLE `test` DROP `id`;
ALTER TABLE `test` AUTO_INCREMENT = 1;
ALTER TABLE `test` ADD `id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST;

Also, this bash file generate a query which reset the PK by a cross join:

#!/usr/bin/env bash

TABLE_NAME=$1
PK_COLUMN_OF_TABLE=$2

echo "UPDATE $TABLE_NAME CROSS JOIN (SELECT @cur := 0) AS init SET $TABLE_NAME.$PK_COLUMN_OF_TABLE = @cur := @cur+1;"
echo "SET @max = (SELECT MAX($PK_COLUMN_OF_TABLE) FROM $TABLE_NAME);"
echo "SET @query = CONCAT(\"ALTER TABLE $TABLE_NAME AUTO_INCREMENT = \", @max);"
echo "PREPARE STATEMENT FROM @query;"
echo "EXECUTE STATEMENT;"
echo "DEALLOCATE PREPARE STATEMENT;"