【解決方法】このコードを SQL で実行しようとしましたが、いくつかのエラーがあるようです

[ad_1]

SQL

CREATE TABLE vendor (
V_code INTEGER NOT NULL UNIQUE,
V_name VARCHAR(35) NOT NULL,
V_contact VARCHAR(25) NOT NULL,
V_Year_founded DATE NOT NULL,
V_phone CHAR(12) NOT NULL,
V_state CHAR(2) NOT NULL,
PRIMARY KEY (V_code)) engine=InnoDB;

SQL

CREATE TABLE product (
P_code INTEGER NOT NULL UNIQUE,
P_descript VARCHAR(35) NOT NULL,
P_quan SMALLINT NOT NULL,
P_price DECIMAL(8,2) NOT NULL,
P_discount DECIMAL(5,2) NOT NULL,
V_code INTEGER,
PRIMARY KEY (P_code),
FOREIGN KEY (V_code) REFERENCES vendor(V_code)
)engine=InnoDB;

テーブルに値を挿入する

SQL

INSERT INTO vendor
VALUES (21225,'Bryson, Inc.','Smithson','1990-10-08','723-223-3234','TN'),
(21226,'D&E Supply','Corener','1985-08-08','974-113-3255','VA'),
(21227,'Rubicon Systems','Hakford','1979-03-08','322-113-3255','CA');

SQL

INSERT INTO product
VALUES
(01,'Titanium drill bit',75, 141.50, 0.06,21226),
(02,'Gold drill bit', 66, 19.50, 0.08,21227),
(03,'Silver drill bit', 62, 8.50, 0.5,21225),
(04,'Aluminum drill', 61, 6.50, 0.9,21225),
(05,'Silver drill bit', 62, 12.50, 0.5,21227),
(06,'Gold drill bit', 66, 16.50, 0.28,21225);