/SQL/SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"

SQLSTATE[42000]: Syntax error or access violation: 1075 Incorrect table definition; there can be only one auto column and it must be defined as a key"

$table->integer('thnajrn_id', 10)->unsigned();
to
$table->integer('thnajrn_id')->unsigned();
or try
table->integer('thnajrn_id')->length(10)->unsigned();

Syntax error or access violation: 1075 Incorrect table def inition; there can be only one auto column and it must be defined as a key

$table->integer('thnajrn_id')->unsigned();

Source: stackoverflow.com

Similar codes

1 vote136 views1 answer
Clear screen command in psql
SQL
0 vote157 views2 answers
Mysql add days to date
SQL
0 vote127 views1 answer
Learn sqlite dart
SQL
21 votes128 views1 answer
Cheatsheet for sql
SQL
2 votes142 views1 answer
How to Add a Default Value to a Column in MS SQL Server
SQL
3 votes126 views1 answer
Select without null values sql
SQL
1 vote127 views1 answer
Login to database mysql terminal
SQL
0 vote130 views1 answer
Select only one row sql
SQL
0 vote138 views1 answer
How to remove default in mysql
SQL
10 votes125 views2 answers
Linux command line import mysql database
SQL