-------------------------- structure for v_shop_ex
-------------------------- VIEW IF EXISTS `v_shop_ex`; ALGORITHM = UNDEFINED DEFINER = `root` @ `%` SQL SECURITY DEFINER VIEW `v_shop_ex` AS select `shop_ex`. `ID` AS `ID`, `shop`. `Name_shop` AS `Name_shop`, `production`. `Name` AS `Name`, `production`. `Price` AS `Price` from ((`shop_ex` join `shop`) join `production`) where ((`shop_ex`. `Shop_ID` = `shop`. `ID`) and (`production`. `ID `=` shop_ex `.` Production_ID `)) order by` shop `. `Name_shop`;
-------------------------- structure for Stored_pr
-------------------------- PROCEDURE IF EXISTS `Stored_pr`;;; DEFINER = `root` @ ` localhost `PROCEDURE` Stored_pr `() p1 INT DEFAULT 0; production. ID into p1 FROM production where production. Price = 1500; into test (ts) values ​​(p1);;;;
--------------------------
-------------------------- INTO `clients` VALUES ('1 ', null,' Karlenok ') ; INTO `clients` VALUES ('2 ', null,' Kozak '); INTO `clients` VALUES ('3', null, 'Sobko'); INTO `clients` VALUES ('4 ', null,' Lapuhin ' ); INTO `manufacturer` VALUES ('1 ',' ZIKO '); INTO `manufacturer` VALUES ('2', 'Bel-Zoloto'); INTO `manufacturer` VALUES ('3 ',' Golden_maiden '); INTO `manufacturer` VALUES ('5 ',' MegaZord '); INTO `metall` VALUES ('1', 'Р-РѕР"РС•С, РС•'); INTO` metall `VALUES ('2 ',' РРЋРОјСР‚РОјР В± СР‚РС• ' ); INTO `metall` VALUES ('3 ',' РСџР "Р В° С, РеРР…Р В° '); INTO` production `VALUES ('1', 'Ring', '1 ', '1', '1 ', '369 '); INTO `production` VALUES ('2', 'Jewel', '3 ', '2', '3 ', '896'); INTO `production` VALUES ('5 ',' Mega_gold ', '3 ', '1', '2 ', '1500'); INTO `shop` VALUES ('1 ',' ZIKO-1 '); INTO `shop` VALUES ('2', 'Shop3'); INTO `shop` VALUES ('3 ',' BelTrans '); INTO `shop` VALUES ('5', 'GoldenMaiden'); INTO `shop_ex` VALUES ('1 ', '1', '2 ', '4' ); INTO `shop_ex` VALUES ('2 ', '2', '1 ', '4 fg'); INTO `shop_ex` VALUES ('3 ', '1', '1 ', null); INTO `shop_ex` VALUES ('4 ', '3', '2 ', null); INTO `shop_ex` VALUES ('5', '2 ', '2', null); INTO `shop_ex` VALUES ('8 ', '5 ', '5', null); INTO `stone` VALUES ('1 ',' РС’Р "РС?Р В° Р В· '); INTO` stone `VALUES ('2', 'Р СР‚РеР" ; РЕР В° РР…С, '); INTO `stone` VALUES ('3', 'РС™СР‚РОјРС?РР…РеР №'); INTO `suppliers` V...
