Sql

Search

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();

Comment

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();

Comment

PREVIOUS	NEXT

Code Example
Sql :: select query in mongodb
Sql :: offset in postgresql example
Sql :: insert json file to mssql
Sql :: oracle merge insert if not exists
Sql :: sql check constraint
Sql :: How to create a comulative Sum column in mysql
Sql :: index postgres
Sql :: drop databse
Sql :: postgresql inheritance
Sql :: t sql cursor tr
Sql :: postgresql alter column data type from integer to integer array
Sql :: db count rows
Sql :: linq inner join
Sql :: mysql loop through databases and execute query
Sql :: sql default
Sql :: T-SQL and the WHERE LIKE %Parameter% clause
Sql :: set value to null postgres
Sql :: sql order by
Sql :: replace function in sql
Sql :: join multiple tables in sql
Sql :: update select sql
Sql :: t sql return on letters only
Sql :: how to print out column name differently in mysql
Sql :: sorting desc in sql
Sql :: python list from sql
Sql :: insert sql
Sql :: sql check
Sql :: lumen
Sql :: sql select condition with left join
Sql :: how to install mysql without admin rights

Search

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"

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

ADD CONTENT