JM
Size: a a a
JM
JM
A
I
К
A
JM
JM
A
К
JM
A
I
JM
А
SK
K
public static function updateAutoIncrement(string $tableName): int
{
// $max = DB::table('users')->max('id') + 1;
// DB::statement("ALTER TABLE {$tableName} AUTO_INCREMENT = $max");
$sql = 'SET @m = (SELECT MAX(id) + 1 FROM `' . $tableName . "`);
SET @s = CONCAT('ALTER TABLE " . $tableName . " AUTO_INCREMENT=', @m);
PREPARE stmt1 FROM @s;
EXECUTE stmt1;
DEALLOCATE PREPARE stmt1;";
try {
DB::statement($sql);
} catch (\Throwable $exception) {
return false;
}
}
AK
А
A