Member Avatar for vedro-compota

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
  • 99 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by vedro-compota
Member Avatar for andrewschools

It should be

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

You misspelled NUMERIC

Edited by andrewschools because: n/a
commented: ++++ +1
Member Avatar for vedro-compota

really. Thank you)) typo in my tutorial)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.