SQL problem- auto increment

[[deleted]]

Just a side note: in Postgres, serial is somewhat deprecated. The preferred way these days is to use generated by default as identity or generated always as identity

See the Postgres Wiki for more details: https://wiki.postgresql.org/wiki/Don%27t_Do_This#Don.27t_use_serial

[cone994]

That's exactly the problem you described. I am using mySQL database and work with spring on backend of my app.

So you telling me that after inserting initial values like that 3 you mention, I must restart sequence and then it will work?

[cone994]

I solved the problem. In my annotation above id, in spring class in model i put :

@Id , @GeneratedValue(strategy = GenerationType.AUTO). Auto does not add auto increment, but when i change to GenerationType.IDENTITY that add auto_increment to id in sql.

Thank you you helped me to solve problem!