What is the syntax error in Create table statement?

Question

I'm sorry if this is too easy, but I'm tired and cannot seem to solve this on my own. Can anyone see what is wrong with this command?

create table Users (
   user_id NUMBER(4) PRIMARY KEY ,
   username VARCHAR2(16) NOT NULL,
   password VARCHAR2(16) NOT NULL,
   first_name VARCHAR2(20) NOT NULL,
   last_name VARCHAR2(20) NUT NULL,
);

Edit: Thanks all. Problem solved. It was the last comma and the NUT :P

Which database software are you trying to create this table in? What error message do you get? — Datajam
– Datajam, Commented May 25, 2012 at 8:51
You've got an extra comma after the last column declaration. You've also put "NUT" instead of "NOT" on the last column too! — Bridge
– Bridge, Commented May 25, 2012 at 8:51

juergen d · Accepted Answer · 2012-05-25 08:50:13Z

7

Do this

create table Users (
    user_id numeric(4) PRIMARY KEY ,
    username VARCHAR(16) NOT NULL,
    password VARCHAR(16) NOT NULL,
    first_name VARCHAR(20) NOT NULL,
    last_name VARCHAR(20) NOT NULL
);

I Changed:

number to numeric
removed last comma
varchar2 to varchar
NUT to NOT

answered May 25, 2012 at 8:50

juergen d

205k40 gold badges304 silver badges377 bronze badges

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

3 Comments

Ali Bassam Over a year ago

I'm using Oracle Express Edition, can you tell me whats the difference between the one I used and the ones you used?

FrontEnd Expert Over a year ago

what is the difference between varchar2 and varchar here

juergen d Over a year ago

@AliBassam: Here is an overview. You can use your data types. You did not specify which DB engine you are using and NUMBER and VARCHAR2 are not available on all DB Engines. Since you are using Oracle these types are fine too.

ericosg · Accepted Answer · 2012-05-25 08:52:22Z

3

Try

create table Users (
    user_id NUMBER PRIMARY KEY ,
    username VARCHAR2(16) NOT NULL,
    password VARCHAR2(16) NOT NULL,
    first_name VARCHAR2(20) NOT NULL,
    last_name VARCHAR2(20) NOT NULL
);

answered May 25, 2012 at 8:52

ericosg

4,9574 gold badges41 silver badges59 bronze badges

Comments

Treffynnon · Accepted Answer · 2012-05-25 12:51:15Z

3

Try removing the last comma and change NUT to NULL.

edited May 25, 2012 at 12:51

Treffynnon

21.6k6 gold badges68 silver badges99 bronze badges

answered May 25, 2012 at 8:50

mvoelkl

1431 silver badge10 bronze badges

Comments

CatchingMonkey · Accepted Answer · 2012-05-25 08:51:28Z

1

Im assuming this is for SQL SERVER?

   CREATE TABLE Users ( 
        user_id INT PRIMARY KEY 
    ,   username VARCHAR(16) NOT NULL
    ,   [password] VARCHAR(16) NOT NULL
    ,   first_name VARCHAR(20) NOT NULL
    ,   last_name VARCHAR(20) NOT NULL 
    )

answered May 25, 2012 at 8:51

CatchingMonkey

1,3912 gold badges14 silver badges37 bronze badges

1 Comment

FrontEnd Expert Over a year ago

error is- right syntax to use near '[password] VARCHAR(16) NOT NULL , first_name VARCHAR(20) NOT NULL , ' at line 4

Collectives™ on Stack Overflow

What is the syntax error in Create table statement?

4 Answers 4

3 Comments

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

3 Comments

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related