Search
 
SCRIPT & CODE EXAMPLE
 

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"

$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 :: unsigned int in mysql 
Sql :: sql concat 
Sql :: mysql current time 
Sql :: mysql event last execution 
Sql :: postgre describe table 
Sql :: mysql backup table 
Sql :: mysql union 
Sql :: foreign key constraint in ms sql 
Sql :: update with join 
Sql :: laravel general error 2006 mysql server has gone away 
Sql :: check table exist postgresql 
Sql :: delete ids between sql 
Sql :: sql server datetime to string 
Sql :: add colum date in sql 
Sql :: oracle difference between two dates in years 
Sql :: mysql select date range last 30 days 
Sql :: output table plsql 
Sql :: rename table column name in mysql 
Sql :: create delete procedure mysql 
Sql :: how to get 30 days previous date in mysql 
Sql :: sql between operator 
Sql :: MySQL get all previous date record 
Sql :: mysql multiple order by 
Sql :: mariadb date equals to current_date plus days 
Sql :: installing mysql on centos 7 
Sql :: 11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly. 
Sql :: mysql function variable 
Sql :: how to delete a table in mysql 
Sql :: find number of entries sql 
Sql :: Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint 
ADD CONTENT
Topic
Content
Source link
Name
5+5 =