auto increment issue

Question

hi,could someone please explain why this table creation would show an error because of the auto_increment constraint? or how to fix it.

https://code.sololearn.com/cUgD316ktFhP

PS: i only saved the code in the python environment(form link) because the site doesn't allow me to directly write the SQL code hear.

Answer 1

You're probably using a SQL flavor that doesn't use auto_increment. (SL uses PostgreSQL.)
https://www.w3schools.com/SQl/sql_autoincrement.asp
https://www.educba.com/postgresql-auto-increment/

Answer 2

That was very helpful thanks.