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
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started