Search
 
SCRIPT & CODE EXAMPLE
 

SQL

ERROR: syntax error at or near "AUTO_INCREMENT" posgtresql

Use SERIAL instead OF AUTO_INCREMENT
Comment

syntax error at or near "AUTO_INCREMENT"

CREATE TABLE site_position_data_new_table (
	id INT SERIAL NOT NULL,
	workspace_name VARCHAR(128) DEFAULT NULL,
	workspace_id INT DEFAULT NULL,
	workspcace_tracking_frequency VARCHAR(45) DEFAULT NULL,
	search_engine VARCHAR(128) DEFAULT NULL,
	search_engine_id INT DEFAULT NULL,
	search_term VARCHAR(128) DEFAULT NULL,
	period VARCHAR(45) DEFAULT NULL,
	position INT DEFAULT NULL,
	feature VARCHAR(45) DEFAULT NUL,
	url VARCHAR(2047) DEFAULT NULL,
	site_id INT DEFAULT NULL,
	site_label VARCHAR(256) DEFAULT NULL,
	UNIQUE INDEX key_COMPOUND (
		period, search_engine_id, search_term,
		workspace_id, position, site_id
	),
	PRIMARY KEY(id)
)	DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci ENGINE = InnoDB;
Comment

PREVIOUS NEXT
Code Example
Sql :: Pl/Sql table based record 
Sql :: denormalization in sql example 
Sql :: psql invalid command N 
Sql :: create procedure 
Sql :: sql quary intervewi question 
Sql :: default column value in sql same as another column laravel 
Sql :: convert .mdf to .bak 
Sql :: postgres advance table id count 
Sql :: insert into from 
Sql :: mysql allow connection from any host 
Sql :: create and attach user to a postgresql database 
Sql :: mysql copy data from one table to another 
Sql :: sql server get week dates from week number 
Sql :: create user in mysql 
Sql :: sqlite trim 
Sql :: oracle job session 
Sql :: sqlalchemy filter by relationship 
Sql :: soql last year 
Sql :: mysql current date between two dates 
Sql :: how to add amount between date in sql 
Sql :: adding column 
Sql :: ranking functions in sql 
Sql :: cardinality example sql 
Sql :: Create table if not exist with exceptions 
Sql :: sql query checker 
Sql :: drop all tables db2 
Sql :: SQL Modulo (Remainder) Operator 
Sql :: sysdatetimeoffset 
Sql :: deduplicate delimited string bigquery 
Sql :: mysql find char in string 
ADD CONTENT
Topic
Content
Source link
Name
5+3 =