/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 vote288 views1 answer
Select count concat string sql server
SQL
21 votes279 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
0 vote287 views1 answer
Can you write relational algebra into sql queries
SQL
1 vote285 views1 answer
Snowflake rename column name
SQL
-3 votes261 views1 answer
Remove spaces sql 2008
SQL
0 vote313 views2 answers
Insert data mysql with cmd
SQL
0 vote287 views1 answer
How to alter length character varying postgres
SQL
0 vote331 views1 answer
Site:av.ru "files"
SQL
0 vote268 views1 answer
On update current_timestamp jpa
SQL
1 vote358 views2 answers
Coderbyte sql solutions
SQL