Advertisement
Genral

product_DB

Jun 17th, 2024
673
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.35 KB | Source Code | 0 0
  1. CREATE TABLE `product` (
  2.   `pId` int(11) NOT NULL AUTO_INCREMENT,
  3.   `pName` varchar(50) NOT NULL,
  4.   `pCatID` int(11) NOT NULL,
  5.   `pBarcode` varchar(50) NOT NULL,
  6.   `pCost` float NOT NULL,
  7.   `pPrice` float NOT NULL,
  8.   `image` longblob NOT NULL,
  9.   PRIMARY KEY (`pId`)
  10. ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  11.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement