Design Product Table in SQL when you don't know how is foreign keys works in SQL 🤣
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
-- -- Table structure for table `products` -- CREATE TABLE `products` ( Â `product_id` int(100) NOT NULL, Â `product_cat` int(100) NOT NULL, Â `product_brand` int(100) NOT NULL, Â `product_title` varchar(255) NOT NULL, Â `product_price` int(100) NOT NULL, Â `product_desc` text NOT NULL, Â `product_image` text NOT NULL, Â `product_keywords` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8; |