/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 vote264 views1 answer
Mysql coalesce
SQL
4 votes203 views1 answer
Mysql biginteger size
SQL
3 votes201 views2 answers
Sql asc
SQL
4 votes216 views1 answer
Is there any command to change postgres password
SQL
2 votes231 views1 answer
Sql update \
SQL
3 votes214 views1 answer
Select database in sql
SQL
0 vote279 views1 answer
Sql get table last modified time
SQL
0 vote241 views1 answer
Ceil upto 2 decimal place mysql
SQL
0 vote204 views1 answer
Oracle sql date summer time
SQL
1 vote209 views1 answer
Delete from inner join sql
SQL