INSERT INTO {tablename} (date, num) VALUES ('2016-07-06') ON DUPLICATE KEY UPDATE num = num + 1$form = ActiveForm::begin([
'action' => "www.url.com/rest/users/{$id}"
])CREATE PROCEDURE `make_data`()
BEGIN
DECLARE i INT DEFAULT 1;
WHILE i < 500000 DO
<тут INSERT запрос>
SET i = i + 1;
END WHILE;
ENDCALL make_data();
UPDATE ps_category SET active = '0' WHERE level = 3 AND id NOT IN (
SELECT DISTINCT(id_category) FROM ps_category_product IN
(SELECT id_product FROM ps_product WHERE active = '1')
)DELETE FROM products_taxons WHERE taxon_id = 693 AND product_id IN (SELECT DISTINCT(product_id) FROM products_taxons taxon_id = 694)<?= Html::a('Принять', ['orders/index','value' => ($orders->id)], ['class'=>'btn btn-primary']) ;?><?= Html::a('Принять', ['orders/take-order','value' => ($orders->id)], ['class'=>'btn btn-primary']) ;?>$get = $request->get(value);$get = $request->get('value');public function actionTakeOrder($value) {}
SELECT cat1.id, cat1.cat_name, cat1.cat_url, cat1.parent, cat2.name as parent_name
FROM `categories` AS cat1
LEFT JOIN `categories` AS cat2 ON cat2.id = cat1.patent
WHERE cat1.`cat_url` = <значение>SELECT `id`, `date`, `status` FROM `table`
WHERE uid IN (1,2,3,4,5) AND (
(reg=1 AND date_last < NOW() - INTERVAL 1 DAY) OR (reg=2 AND date_last < NOW() - INTERVAL 2 DAY)
OR (reg=3 AND date_last < NOW() - INTERVAL 3 DAY))SELECT `id`, `date`, `status` FROM `table` WHERE uid IN (1,2,3,4,5) AND date_last < NOW() - INTERVAL reg DAY$.ajax({
type: "GET",
url : "ТУТ ССЫЛКА",
data: data,
success: function(response) {
console.log(response.status) // код с HTTP статусом ответа
document.getElementById('r').innerHTML = "Успешно";
},
error: function(response) {
document.getElementById('r').innerHTML = "Ошибка.";
}
});$.ajax({
type: "GET",
url : "ТУТ ССЫЛКА",
data: data,
success: function(response) {
document.getElementById('r').innerHTML = "Успешно";
},
error: function(response) {
document.getElementById('r').innerHTML = "Ошибка.";
},
statusCode: {
302: function() {
console.log('redirect');
}
}
});CREATE TRIGGER `add_message` BEFORE INSERT ON `messages` FOR EACH ROW BEGIN
UPDATE user SET sended = sended + 1 WHERE user_id = new.user_id_from;
UPDATE user SET received= received + 1 WHERE user_id = new.user_id_to;
END;