Java SQL syntax error whilst creating table

Question

I'm getting a syntax error on a create table string. I've had a look online to see if there's anything I'm missing but I can't spot what's wrong.

//SQL Statement to create table on phpmyadmin if not exists
    String createTable = "CREATE TABLE IF NOT EXISTS user(\n"
            + "id INT NOT NULL AUTO INCREMENT \n"
            + "username VARCHAR(20) NOT NULL \n"
            + "realname VARCHAR(100) NOT NULL \n"
            + "password VARCHAR(100) NOT NULL \n"
            + "email VARCHAR(100) NOT NULL \n"
            + "gym VARCHAR(100) \n"
            + "belt VARCHAR(100) \n"
            + "dateofbirth DATE NOT NULL \n"
            + "profilepic LONGBLOB \n"
            + "biography VARCHAR(1000) \n"
            + "motto VARCHAR(200) \n"
            + "PRIMARY KEY (id)\n"
            + ")";

Output says;

"near 'AUTO INCREMENT
username VARCHAR(20) NOT NULL
realname VARCHAR(100) NOT NULL
p' at line 2"

Shouldn't there be commas between your column declarations?

khelwood
– khelwood

2018-12-01 19:41:58 +00:00
Commented Dec 1, 2018 at 19:41 — khelwood
– khelwood, Commented Dec 1, 2018 at 19:41

forpas · Accepted Answer · 2018-12-02 06:40:38Z

1

Drop all \n and replace with , after each column except for the last.
Also for MySql it's AUTO_INCREMENT, not AUTO INCREMENT.

edited Dec 2, 2018 at 6:40

answered Dec 1, 2018 at 19:42

forpas

165k10 gold badges51 silver badges85 bronze badges

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

Collectives™ on Stack Overflow

Java SQL syntax error whilst creating table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related