/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

11 votes790 views4 answers
Reset identity column values in sql server
SQL
0 vote352 views1 answer
ORACLE SUBSTRING SYNTAX
SQL
5 votes355 views2 answers
Get columns number sql
SQL
1 vote349 views1 answer
Add current timestamp in mysql
SQL
9 votes350 views1 answer
Sql server get utc date
SQL
0 vote355 views1 answer
Table values functions in SQL
SQL
0 vote365 views1 answer
Get all employee of salary if more than in sql
SQL
3 votes357 views2 answers
Mysql create database
SQL
0 vote379 views1 answer
SQL Hello, [firstname] [lastname]
SQL
0 vote323 views1 answer
Mysql find non alphanumeric characters
SQL