Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions