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

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? (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

Explanation / Answer

CREATE TABLE QOPRODUCT ( P_CODE VARCHAR(10) PRIMARY KEY,
P_DESCRIPT VARCHAR(35) NOT NULL, P_INDATE DATE NOT NULL,
P_QOH NUMERIC NOT NULL, P_MIN NUMERIC NOT NULL,
P_PRICE DECIMAL(8,2) NOT NULL,
P_DISCOUNT DECIMAL(4,2) NOT NULL,
V_CODE NUMERIC REFERENCES QOVENDOR, // reference used for the foreign key so create a table name QOVENDER and V_CODE as a primary key//
P_MIN_ORDER NUMERIC, P_REORDER NUMERIC ); //error in this line because u dont give a space between order and numeric value.

CREATE TABLE QOVENDOR(V_CODE NUMERIC PRIMARY KEY);

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.