WITH
cte AS (
SELECT name,
SPLIT_PART(name, ' ', 1) first,
SPLIT_PART(name, ' ', -1) last
FROM outcomes
),
cte2 AS (
SELECT name, first, last,
LENGTH(name) - LENGTH(first) - LENGTH(last) - 2 middlelen
FROM cte
)
SELECT name,
first || ' ' || REPEAT('*', middlelen) || ' ' || last starname
FROM cte2
WHERE middlelen > 0SELECT *
FROM table
WHERE path REGEXP '\\/(?:users|\\{[a-z]+\\})\\/(?:group|\\{[a-z]+\\})\\/(?:1|\\{[a-z]+\\})\\/(?:count|\\{[a-z]+\\})\\/(?:10|\\{[a-z]+\\})'<?php
preg_match('~/users/group/(?P<id>[^/]+)/count/(?P<cnt>[^/]+)~', '/users/group/1/count/10', $matches);
print_r($matches);
// Array(
// [0] => /users/group/1/count/10
// [id] => 1
// [1] => 1
// [cnt] => 10
// [2] => 10
// )SELECT DATE(payment_date) AS `date`, SUM(amount) AS income
FROM payment
WHERE payment_date >= '2005-07-01' AND payment_date < '2005-08-01'
GROUP BY `date`WITH `t` (`row`) AS (
SELECT 1
UNION SELECT 2
UNION SELECT 3
)
SELECT `row`, RAND("totally_not_random"), RAND(0), RAND(1) FROM `t`| row | RAND("totally_not_random") | RAND(0) | RAND(1) |
| --- | -------------------------- | ------------------- | ------------------ |
| 1 | 0.15522042769493574 | 0.15522042769493574 | 0.4054035371219773 |
| 2 | 0.620881741513388 | 0.620881741513388 | 0.8716141803857071 |
| 3 | 0.6387474552157777 | 0.6387474552157777 | 0.1418603212962489 |DELETE FROM order_clients
WHERE ctid IN (
SELECT DISTINCT o.ctid
FROM order_clients AS o
JOIN order_clients AS t
ON t.client_id = o.client_id AND t.order_id = o.order_id
AND t.linked_at < o.linked_at
LIMIT 1000
);SELECT io.Date, io.IN, io.OUT, m.DESCRIPTION name,
p1.DESCRIPTION parent, p2.DESCRIPTION grandparent
FROM TABLE_IN_OUT io
JOIN TABLE_REFERENCE m ON m.ID = io.ID
LEFT JOIN TABLE_REFERENCE p1 ON p1.ID = m.ID_PARENT
LEFT JOIN TABLE_REFERENCE p2 ON p2.ID = p1.ID_PARENT- and visit_date between 2023-05-01 and 2023-09-30
+ and visit_date between '2023-05-01' and '2023-09-30'SELECT q.*, s.Name AS SectionName, t.Name AS TopicName,
th.Name AS ThemeName
FROM GD_Citizen_ClassifierBase AS q
JOIN GD_Citizen_ClassifierBase AS s ON s.id = q.Section
JOIN GD_Citizen_ClassifierBase AS t ON t.id = q.Topic
JOIN GD_Citizen_ClassifierBase AS th ON th.id = q.ThemeSELECT `url` AS `old_url`, REPLACE(`url`, '_', '-') AS `new_url`
FROM `mg_product`
WHERE LOCATE('_', `url`')
INTO OUTFILE 'replace_urls'UPDATE `mg_product`
SET `url` = REPLACE(`url`, '_', '-')CREATE TABLE IF NOT EXISTS users (id INT, class INT, liter TEXT)А если она уже существует? Колонка liter в ней есть?
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);ini_set('error_reporting', E_ALL);
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);WITH RECURSIVE `cte` AS (
SELECT `id`, `pid`, `name`, 0 AS `level`
FROM `table`
UNION SELECT `p`.`id`, `p`.`pid`, `p`,`name`, `cte`.`level` + 1 AS `level`
FROM `cte`
JOIN `table` AS `p` ON `p`.`id` = `cte`.`pid`
)
SELECT `id`, `name`, `level`
FROM `cte`
ORDER BY `level`