Note that AUTO_INCREMENT is not a standard SQL keyword, but rather an additional keyword defined by certain DBMS and/or SQL parsers. The syntax constraints/rules regarding this keyword can also differ between different DBMS/parsers implementing AUTO_INCREMENT. Thus, i would suggest you add as a tag to or mention in your question the DBMS you are using. (As an example, theoretically assuming the DBMS in use is mysql: If the reader would know that you are using mysql, then thy can reasonably conclude that the syntax of your create table statement is violating mysql's syntax rules, and give a meaningful answer that both explaines the problem and provides actionable advice...)

I am directly using SQL from Java. I don't have any idea of backend. I am sure that it's not mysql. But it's something else. What's that? I don't know..

Try figuring out the actual DBMS backend (or SQL bridge/adapter/parser/translation layer) you are using. Unfortunately, i don't know of a way to do that in SQL that would work across different DBMS products. If you can't figure it out, and no one comes up with a "what a lucky blind guess, i'm glad it helped you" kind of answer or comment, i guess you could use Google to get some overview of DBMS products that support the AUTO_INCREMENT keyword. Even if it would be an incomplete overview, it would still be something to get you started solving the problem. Then, one by one, you would look up the documentation for those DBMS' and see how a correct primary key column definiton with AUTO_INCREMENT should look like for that particular DBMS and try it out. Do this until you find a syntax that works in your case...