By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
SELECT VERSION();
| VERSION() |
|---|
| 8.0.36 |
DROP TABLE IF EXISTS `product`;
CREATE TABLE IF NOT EXISTS `product` (
`p_code` VARCHAR(10) PRIMARY KEY,
`p_descript` VARCHAR(35) NOT NULL,
`p_indate` DATE NOT NULL,
`p_qoh` SMALLINT NOT NULL,
`p_min` SMALLINT NOT NULL,
`p_price` NUMERIC(8, 2) NOT NULL,
`p_discount` NUMERIC(5, 2) NOT NULL,
`v_code` INTEGER NOT NULL/*,
FOREIGN KEY (`v_code`) REFERENCES `vendor`(`v_code`) ON UPDATE CASCADE*/
) ENGINE=InnoDB;
INSERT INTO `product`
VALUES (
'11QER/ 31',
-- ' Power painter', 15 psi., 3- nozzle',
' Power painter\', 15 psi., 3- nozzle',
-- '03- Nov- 11',
STR_TO_DATE('03- Nov- 11', '%d- %b- %y'),
8,
5,
109.99,
0.00,
25595
);
SELECT
`p_code`,
`p_descript`,
`p_indate`,
`p_qoh`,
`p_min`,
`p_price`,
`p_discount`,
`v_code`
FROM
`product`;
| p_code | p_descript | p_indate | p_qoh | p_min | p_price | p_discount | v_code |
|---|---|---|---|---|---|---|---|
| 11QER/ 31 | Power painter', 15 psi., 3- nozzle | 2011-11-03 | 8 | 5 | 109.99 | 0.00 | 25595 |