0

Hi guys! I can not understand - what is wrong with this simple line -

create table SUBJECT ( SUBJ_ID NUMERUC not null, SUBJ_NAME VARCHAR(100));

error message -

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'create table SUBJECT ( SUBJ_ID NUMERUC not null, SUBJ_NAME VARCHAR(100))' at line 1

Please help) Thanks in advance)

2
Contributors
2
Replies
3
Views
6 Years
Discussion Span
Last Post by vedro-compota
1

It should be

create table SUBJECT ( SUBJ_ID NUMERIC not null, SUBJ_NAME VARCHAR(100))

You misspelled NUMERIC

Edited by andrewschools: n/a

Votes + Comments
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.