Question: I am having trouble understanding what is the error. Can someone please help me mysql> CREATE TABLE QOPRODUCT ( -> P_CODE Display all 779 possibilities?

I am having trouble understanding what is the error. Can someone please help me

mysql> CREATE TABLE QOPRODUCT (

-> P_CODE

Display all 779 possibilities? (y or n)

-> P_CODE VARCHAR(10) PRIMARY KEY,

-> P_DESCRIPT VARCHAR(35) NOT NULL,

-> P_INDATE DATE NOT NULL,

-> P_QOH

Display all 779 possibilities? (y or n)

-> P_QOH NUMERIC NOT NULL,

-> P_MIN

Display all 779 possibilities? (y or n)

-> P_MIN NUMERIC NOT NULL,

-> P_PRICE DECIMAL(8,2) NOT NULL,

-> P_DISCOUNT DECIMAL(4,2) NOT NULL,

-> V_CODE

Display all 779 possibilities? (y or n)

-> V_CODE NUMERIC REFERENCES QOVENDOR,

-> P_MIN_ORDERNUMERIC,

-> P_REORDERNUMERIC);

ERROR 1064 (42000): 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 '

P_REORDERNUMERIC)' at line 10

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!