syntax error in my SQL queries

Question

I have a syntax error in my SQL queries,what's wrong?

this is the query:

    CREATE TABLE post_cat(
    cat_id int(2) AUTO_INCREMENT NOT null PRIMARY key,
    cat_text varchar(255),
    post_cat varchar,
    FOREIGN KEY (post_cat) REFERENCES post(post_cat)
    )

#1005 - Can't create table telegram.post_cat (errno: 150 "Foreign key constraint is incorrectly formed") (Details…) — Mohsen
– Mohsen, Commented Dec 10, 2017 at 18:38
Add your query for adding the post table which hold the post_cat before this query. — MAZux
– MAZux, Commented Dec 10, 2017 at 19:21

Aaron Zolla · Accepted Answer · 2017-12-10 18:21:44Z

3

All varchars need a length specification.

CREATE TABLE post_cat(
cat_id int(2) AUTO_INCREMENT NOT null PRIMARY key,
cat_text varchar(255),
post_cat varchar(1000),
FOREIGN KEY (post_cat) REFERENCES post(post_cat)
);

answered Dec 10, 2017 at 18:21

Aaron Zolla

6221 gold badge6 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mohsen Over a year ago

now I have new error MySQL said: Documentation #1005 - Can't create table telegram.post_cat (errno: 150 "Foreign key constraint is incorrectly formed") (Details…)

Gordon Linoff · Accepted Answer · 2017-12-10 19:12:38Z

2

You need a length for the varchar:

CREATE TABLE post_cat (
    cat_id int(2) AUTO_INCREMENT NOT null PRIMARY key,
    cat_text varchar(255),
    post_cat varchar(255),
    FOREIGN KEY (post_cat) REFERENCES post(post_cat)
);

The length should match the definition in the post table.

Here is a SQL Fiddle showing the table creation.

edited Dec 10, 2017 at 19:12

answered Dec 10, 2017 at 18:21

Gordon Linoff

1.3m62 gold badges705 silver badges857 bronze badges

2 Comments

Mohsen Over a year ago

now I have new error MySQL said: Documentation #1005 - Can't create table telegram.post_cat (errno: 150 "Foreign key constraint is incorrectly formed") (Details…)

Gordon Linoff Over a year ago

post_cat seems like a really strange primary key for a table called post. Nevertheless, the code works with the correct column definitions, as shown in the SQL Fiddle.

Collectives™ on Stack Overflow

syntax error in my SQL queries

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related