/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

3 votes335 views3 answers
Order by postgres
SQL
0 vote343 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
0 vote326 views2 answers
PostgreSQL having
SQL
2 votes308 views1 answer
Docker run postgres locally
SQL
2 votes309 views2 answers
Postgres set user as superuser
SQL
24 votes317 views2 answers
Alter table delete column
SQL
0 vote371 views3 answers
Mysql CAST(amount as float)
SQL
0 vote372 views1 answer
Psql create usr
SQL
0 vote337 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
0 vote340 views2 answers
FIND OUT THE NAME HIGHEST SALARY SQL
SQL