$str = preg_replace_callback(
"/(\w+)(:\w+)?/",
function($matches) {
return '{' . strtoupper($match[1]) . $match[2] . '}';
},
$str
);WITH `cte` AS (
SELECT *, ROW_NUMBER() OVER `w` AS `row_num`
FROM `posts`
WINDOW `w` AS (
PARTITION BY `user_id`
ORDER BY `time` DESC
)
) SELECT *
FROM `cte`
JOIN `users` ON `users`.`id` = `cte`.`user_id`
WHERE `cte`.`row_num` <= 3let str = '(2(3AC)A)';
while (str.includes('(')) {
str = str.replaceAll(/\((\d+)([a-z]+)\)/gi, (match, p1, p2) => p2.repeat(+p1));
}
console.log(str); // ACACACAACACACAcast_ray(5, 5, 0, 10), последняя проверяемая точка будет иметь координаты x_ == 5 и y_ == 15.
const result = [];
for (let i = 1; i < t.length; i += 2) {
const sub = [];
for (j = 0; j < t[0].length; j += 1) {
sub.push([t[0][j], t[i][j], t[i + 1][j]]);
}
result.push(sub);
}
console.log(result);clauses order does not matter
query().select('name').where('id=10').groupBy('age').execute();
// SELECT name WHERE id=10 GROUP BY age
query().groupBy('age').where('id=10').select('name').execute();
// GROUP BY age WHERE id=10SELECT namewhile (ROWS < 2) {if ((arr [i][j - 1] < arr [i][j]) || (arr [i][j - 1] > arr [i][j])){INSERT INTO `table` (`last_data`)
WITH `cte` (`max`) AS (
SELECT MAX(`last_data`)
FROM `table`
) SELECT `max` + 50000 FROM `cte`;почему slick не является функцией?
('.products__slider') - это просто строка, а у строки нет метода .slick
const concat = (str, delim = '', strs = []) => (typeof str === 'string')
? (str1) => concat(str1, delim === null ? '' : delim, [...strs, str])
: strs.join(delim);