Breaking News: Grepper is joining You.com. Read the official announcement!

syntax error at or near "AUTO_INCREMENT"

Palin Lertpoonwasin answered on March 3, 2022 Popularity 7/10 Helpfulness 4/10

answer syntax error at or near "AUTO_INCREMENT"

related ERROR: syntax error at or near "AUTO_INCREMENT" posgtresql

syntax error at or near "AUTO_INCREMENT"

Comment

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;

Popularity 7/10 Helpfulness 4/10 Language sql

Source: Grepper

Tags: near sql syntax-error

Link to this answer
Share Copy Link

Contributed on Aug 19 2022

Palin Lertpoonwasin

0 Answers Avg Quality 2/10

Closely Related Answers

ERROR: syntax error at or near "AUTO_INCREMENT" posgtresql

Comment

Use SERIAL instead OF AUTO_INCREMENT

Popularity 8/10 Helpfulness 6/10 Language sql

Source: Grepper

Tags: syntax-error sql near syntax-

Link to this answer
Share Copy Link

Contributed on Mar 03 2022

urban

0 Answers Avg Quality 2/10

syntax error at or near "AUTO_INCREMENT"

Contents

More Related Answers

syntax error at or near "AUTO_INCREMENT"

Closely Related Answers

ERROR: syntax error at or near "AUTO_INCREMENT" posgtresql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.