/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

10 votes254 views6 answers
Mysql set root password
SQL
1 vote213 views2 answers
Sql left characters
SQL
0 vote223 views1 answer
How to login to mysql in homestead
SQL
-1 vote226 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL
0 vote230 views1 answer
Add a new column into table
SQL
-1 vote302 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
6 votes229 views2 answers
Mysql execute file
SQL
2 votes175 views1 answer
Oracle sql drop column if exists
SQL
0 vote220 views1 answer
Sql change column in existing table
SQL
3 votes222 views2 answers
Sql paging query
SQL