/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

0 vote100 views1 answer
Postgresql create table default value timestamp
SQL
8 votes176 views1 answer
Oracle search code in packages
SQL
3 votes100 views1 answer
Search for column name in psql
SQL
2 votes101 views1 answer
Alter table add multiple columns postgresql
SQL
7 votes110 views1 answer
Connect mysql docker
SQL
0 vote111 views1 answer
Html css mobile menu arrow dropdown
SQL
-1 vote120 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
2 votes117 views1 answer
Mysql select default if null
SQL
0 vote137 views1 answer
Add new column in sql with foreign key
SQL
3 votes127 views2 answers
Synonym oracle
SQL