Insert into c помощью планировщика задач msql

211
07 марта 2018, 08:37

Здравствуйте! Пытаюсь создать планировщик задач для добавления товарных позиций на сайт. К сожалению, он не работает пишет: A comma or a closed braket was expected. Прошу помочь объяснить что я делаю не так:

DELIMITER $$
CREATE EVENT timeIN ON SCHEDULE
EVERY 1 MINUTE
COMMENT 'Внесение новых товаров акционными.'
DO BEGIN
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (1233, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 1233)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (1835, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 1835)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (2414, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 2414)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (2980, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 2980)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (2981, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 2981)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (2982, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 2982)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (2983, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 2983)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (2984, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 2984)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (2985, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 2985)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (2986, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 2986)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (2987, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 2987)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3507, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3507)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3508, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3508)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3509, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3509)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3510, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3510)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3511, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3511)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3511, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3511)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3512, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3512)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3843, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3843)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3845, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3845)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3847, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3847)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3848, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3848)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3849, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3849)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3850, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3850)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3851, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3851)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3852, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3852)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3853, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3853)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3854, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3854)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (3855, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 3855)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (4217, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 4217)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (4218, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 4218)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (4219, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 4219)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (4220, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 4220)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (4220, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 4220)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (4429, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 4429)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (4443, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 4443)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (4444, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 4444)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (4445, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 4445)*0.95));
INSERT INTO `dmx_product_special`(`product_id`, `customer_group_id`, `price`) VALUES (4446, 1, ((SELECT dmx_product.price FROM dmx_product WHERE dmx_product.product_id = 4446)*0.95));
END $$
DELIMITER ;
Answer 1
INSERT INTO `dmx_product_special`(`product_id`,`customer_group_id`,`price`) 
VALUES (
            1233, 
            1, 
            (
                (    SELECT dmx_product.price 
                     FROM dmx_product 
                     WHERE dmx_product.product_id = 1233
                )*0.95 -- ??????????
            )
      );

INSERT INTO `dmx_product_special`(`product_id`,`customer_group_id`,`price`) 
VALUES (
            1233, 
            1, 
            (    SELECT dmx_product.price*0.95 -- !!!!!!!!!
                 FROM dmx_product 
                 WHERE dmx_product.product_id = 1233
            )
      );
READ ALSO
Почему периодически отваливается MySql?

Почему периодически отваливается MySql?

На корпоративном портале иногда кратковременно отваливается MySql

216
PImcore hook into pre-update event on dataobject

PImcore hook into pre-update event on dataobject

Доброго времени суток! Действовал по мануалу:

315
Разделить оформление заказа в WooCommerce

Разделить оформление заказа в WooCommerce

После выбора товара человек нажимает "оформить заказ" и попадает на страницу с формой проверки данных, куда доставить и выбора способа оплатыЭто...

257
Как лучше всего подгрузить поля из БД?

Как лучше всего подгрузить поля из БД?

Всем дорого времени сутокНа сайте есть поля с выпадающим списком, поле используется для того чтобы пользователь мог выбрать нужный ему город...

226