-- ----------------------------
-- Table structure for `category`
-- ----------------------------
DROP TABLE IF EXISTS `category`;
CREATE TABLE `category` (
  `id` int(10) NOT NULL AUTO_INCREMENT,
  `categoryName` varchar(50) DEFAULT NULL,
  `image` longblob,
  `imageName` varchar(50) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of category
-- ----------------------------
INSERT INTO `category` VALUES ('1', 'ChildrensComputers', null, 'ChildrensComputers.png', 'Детские компьютеры');

-- ----------------------------
-- Table structure for `product`
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
  `id` bigint(30) NOT NULL AUTO_INCREMENT,
  `category_id` int(10) NOT NULL,
  `price` bigint(30) NOT NULL,
  `productName` varchar(100) DEFAULT NULL,
  `productDescription` varchar(10000) DEFAULT NULL,
  `is_active` tinyint(2) NOT NULL,
  `manufacturer_country_id` int(10) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_category_id` (`category_id`),
  KEY `fk_product_name_id` (`productName`),
  KEY `fk_product_description_id` (`productDescription`(255)),
  KEY `fk_category_manufacturer_id` (`manufacturer_country_id`),
  CONSTRAINT `fk_category_id` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON UPDATE CASCADE,
  CONSTRAINT `fk_category_manufacturer_id` FOREIGN KEY (`manufacturer_country_id`) REFERENCES `manufacturer_country` (`id`) ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

INSERT INTO `product` (`category_id`, `price`, `productName`, `productDescription`, `is_active`, `manufacturer_country_id`) 
VALUES ('1' , '1', '1', '1', '1', '1')

INSERT INTO `product` (`category_id`, `price`, `productName`, `productDescription`, `is_active`, `manufacturer_country_id`) 
VALUES (category.categoryName , '1', '1', '1', '1', '1')
SELECT category.categoryName 
FROM category 
WHERE category.categoryName='ChildrensComputers'

INSERT INTO `product` (`category_id`, `price`, `productName`, `productDescription`, `is_active`, `manufacturer_country_id`) 
VALUES (category.id , '1', '1', '1', '1', '1')
SELECT category.id 
FROM category 
WHERE category.categoryName='ChildrensComputers'


[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT category.id 
FROM category 
WHERE category.categoryName='ChildrensCompu' at line 3

[SQL] INSERT INTO `product` (`category_id`, `price`, `productName`, `productDescription`, `is_active`, `manufacturer_country_id`) 
SELECT category.id  '1', '1', '1', '1', '1'
FROM category 
WHERE category.categoryName='ChildrensComputers'

[Err] 1136 - Column count doesn't match value count at row 1

[SQL] INSERT INTO `product` (`category_id`, `price`, `productName`, `productDescription`, `is_active`, `manufacturer_country_id`) 
SELECT category.id, '1', '1', '1', '1', '1'
FROM category 
WHERE category.categoryName='ChildrensComputers'

Affected rows: 1
Time: 0.035ms