Database
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?
Last updated
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.
Solution
Here is how I do.
$statement = "ALTER TABLE quotations AUTO_INCREMENT = 1;";
DB::unprepared($statement);
Sign in to participate in this thread!
Laravel
Laravel News
Laracasts
Laravel Podcast