Ограничения
При использовании в виде производной таблицы ограничение на количество строк отсутствует.
При использовании в виде предложения VALUES инструкции INSERT... VALUES применяется ограничение в размере 1000 строк. Если число строк превышает 1000, возвращается ошибка 10738. Чтобы вставить более 1000 строк, используйте один из следующих методов:
Создайте несколько инструкций INSERT
Используйте производную таблицу
Выполните массовый импорт данных, используя служебную программу bcp, класс SqlBulkCopy .NET, OPENROWSET (BULK ...) или инструкцию BULK INSERT.
CREATE TABLE `wrdr_promocodes_items` (
`id` INTEGER unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
`code` VARCHAR(100) NOT NULL DEFAULT '',
`discount_amount` INT,
`discount_percent` DECIMAL(3,1),
`num_limit` INT NULL,
`date_limit` DATETIME NULL,
`description` TEXT NOT NULL,
`active` TINYINT unsigned NOT NULL DEFAULT 1
);
SELECT
users.*, categories.key as category
FROM users
JOIN categories ON categories.user_id = users.id
WHERE categories.key = 1
;
delete t.*
from t
left join t t1 on t.a = t1.a and t.id > t1.id
where t1.id is not null;
<meta property="og:site_name" content="SQLIZE.online">
<meta property="og:type" content="website">
<meta property="og:title" content="*************"/>
<meta property="og:description" content="Share SQL shapshot" />
<meta property="og:url" content="https://SQLIZE.online/favicons/sqlize/android-chrome-192x192.png" />
<meta property="og:image:secure_url" itemprop="image" content="https://SQLIZE.online/favicons/sqlize/android-chrome-192x192.png" />
<meta property="og:image" itemprop="image" content="https://SQLIZE.online/favicons/sqlize/android-chrome-192x192.png" />
<meta property="og:image:width" content="566" />
<meta property="og:image:height" content="300" />
<meta property="og:image:type" content="image/png" />
<meta property="og:updated_time" content="1679498154" />
CREATE TABLE users (
id INT NOT NULL AUTO_INCREMENT,
username VARCHAR(50) NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE privileges (
id INT NOT NULL AUTO_INCREMENT,
privilege VARCHAR(50) NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE user_privileges (
user_id INT NOT NULL,
privilege_id INT NOT NULL,
PRIMARY KEY (user_id, privilege_id),
FOREIGN KEY (user_id) REFERENCES users(id),
FOREIGN KEY (privilege_id) REFERENCES privileges(id)
);
select city,
json_object(
'sum1', sum(data->>"$.sum1"),
'sum2', sum(data->>"$.sum2")
) data
from cities
group by city
$str = '[2023-03-14 16:08:42] local.INFO: {"id":"test","object":"object","date":"date"}';
preg_match('@[^{]+({.+})@', $str, $m);
$jsonstr = $m[1];
var_dump(json_decode($jsonstr, 1));
SELECT * FROM `dle_post` WHERE CONCAT('|', `xfields`, '|') LIKE '%|key|123|%'
<?php
$from = DateTime::createFromFormat("m.Y", "1.2023");
$to = DateTimeImmutable::createFromFormat("m.Y", "12.2024");
$interval = DateInterval::createFromDateString('1 month');
while ($from < $to) {
echo $from->format('m.Y') . PHP_EOL;
$from = $from->add($interval);
}
echo $to->format('m.Y') . PHP_EOL;
<?php
$response = '{"status":"success","1":{"transaction":"8025400","email":"Не указана","amount":"21.38","currency":"RUB","currency_amount":"20.00","comission_percent":"6.90","comission_fixed":"0.00","amount_profit":"20.00","method":"Не выбран","payment_id":"1618399991","description":"Покупка доступа на 2 дня","date":"2023-03-13 19:40:46","pay_date":"2023-03-13 19:40:46","transaction_status":"0","custom_fields":"null","webhook_status":"0","webhook_amount":"0"}}';
$data = json_decode($response, true);
$transaction_status = $data["1"]["transaction_status"] ?? -1;
switch ($transaction_status) {
case -1:
echo 'Статус транзакции неизвестен';
exit(0);
case 0:
echo 'Статус транзакции = 0';
exit(0);
default:
echo 'Статус транзакции не равен 0';
}
select
req_id, req_text,
recipient.name as recipient_name,
sender.name as sender_name
from request
join users as recipient on request.recipient_id = recipient.id
join users as sender on request.sender_id = sender.id;
select substring(
'101.139.99.171 20140216044939 news.yandex.ru/2962142 1418 405 Firefox/5.0 (compatible; MSIE 9.0; Windows NT 6.1; WOW64; Trident/5.0; chromeframe/12.0.742.112)n'
from '\d+\.\d+\.\d+\.\d+ (\d{14})'
);