Last active
July 29, 2018 20:50
-
-
Save sebgates/c979cad9c16ddcde69649c8c4ab2b022 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- | |
-- Table structure for table `tbl_products` | |
-- | |
CREATE TABLE `tbl_products` ( | |
`id` int(11) NOT NULL, | |
`product_name` varchar(500) NOT NULL, | |
`price` varchar(500) NOT NULL, | |
`category` varchar(500) NOT NULL | |
) ENGINE=InnoDB DEFAULT CHARSET=utf8; | |
-- | |
-- Dumping data for table `tbl_products` | |
-- | |
INSERT INTO `tbl_products` (`id`, `product_name`, `price`, `category`) VALUES | |
(3, 'Apple IPhone 8', '€850', 'Mobile Phone'), | |
(4, 'Sony Vio', '€1200', 'Laptop'), | |
(5, 'Samsung T.V', '€900', 'T.V'), | |
(6, 'Apple IPAD', '€710', 'Tablet'), | |
(7, 'MacBook Pro', '€1000', 'Laptop'), | |
(8, 'Dell Laptop', '€950', 'Laptop'), | |
(9, 'Canon EOS 700D DSLR Camera', '€550', 'Camera'), | |
(31, 'Apple Mouse', '€70', 'Accessories'); | |
-- | |
-- Indexes for table `tbl_products` | |
-- | |
ALTER TABLE `tbl_products` | |
ADD PRIMARY KEY (`id`); | |
-- | |
-- AUTO_INCREMENT for table `tbl_products` | |
-- | |
ALTER TABLE `tbl_products` | |
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=32; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment