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?
That command doesn't seem to exist in MySQL. See that thread on StackOverflow.
Here is how I do.
$statement = "ALTER TABLE quotations AUTO_INCREMENT = 1;"; DB::unprepared($statement);
Sign in to participate in this thread!