/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

23 votes315 views4 answers
How to show all users in mysql
SQL
0 vote287 views1 answer
Mysql utc timestamp
SQL
0 vote299 views1 answer
Oracle sql count occurrences of value in column
SQL
0 vote292 views1 answer
How to insert multiple rows in mysql using laravel
SQL
0 vote289 views1 answer
Sql delete row from table where id
SQL
0 vote301 views1 answer
Group by two columns postgres
SQL
2 votes297 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote308 views1 answer
Sql filter rows with condition
SQL
0 vote289 views1 answer
Sql add calculated column
SQL
0 vote278 views1 answer
Mysql create table like
SQL