Column Not Allowed error while inserting rows using sequence values

Question

I've already successfully created a Sequence for the criminal_id column in the criminals table, but when I try to insert a new row, I get a "column not allowed" error. Here's the statement I run:

INSERT INTO criminals (criminal_id, last, first)
VALUES (criminals_criminal_id_seq.NEXTVAL, Capps, Johnny);

The error message I get back says my error is in the second line, and states: "column not allowed here." What am I doing wrong?

Is this really about MySQL?

Andriy M
– Andriy M

2014-10-06 18:51:25 +00:00
Commented Oct 6, 2014 at 18:51 — Andriy M
– Andriy M, Commented Oct 6, 2014 at 18:51

Peter Pei Guo · Accepted Answer · 2014-10-04 23:54:08Z

1

You missed some quotes, otherwise it thought those unquoted are column names, thus that error message:

INSERT INTO criminals (criminal_id, last, first)
VALUES (criminals_criminal_id_seq.NEXTVAL, 'Capps', 'Johnny');

answered Oct 4, 2014 at 23:54

Peter Pei Guo

7,89018 gold badges37 silver badges54 bronze badges

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

Collectives™ on Stack Overflow

Column Not Allowed error while inserting rows using sequence values

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related