Back

Reseeding MySQL index


matthewmalone posted 2 years ago

When creating a table ("quotations") in a migration I want to set the index start count...

DB::statement('DBCC CHECKIDENT (\'quotations\', RESEED, 6000);');

The above keep on giving an error "you have an error in your SQL syntax". What am I doing wrong?

ftiersch replied 2 years ago

http://stackoverflow.com/questions/6963363/mysql-dbcc-checkident-syntax-error

That command doesn't seem to exist in MySQL. See that thread on StackOverflow.

monaye replied 2 years ago Solution

Here is how I do.

$statement = "ALTER TABLE quotations AUTO_INCREMENT = 1;";
DB::unprepared($statement);

Sign in to participate in this thread!


We'd like to thank these amazing companies for supporting us