- IN `in_voice_text` TEXT,
- IN `in_voice_translate` TEXT,
+ IN `in_voice_text` TEXT CHARSET utf8mb4,
+ IN `in_voice_translate` TEXT CHARSET utf8mb4,,WHERE
b_calendar_resource.DATE_FROM <= '2024-07-13' + INTERVAL 1 DAY AND
b_calendar_resource.DATE_TO >= '2024-07-13'WITH RECURSIVE `subs` (`name`, `value`, `order`) AS (
SELECT CONCAT('{{> ', `p`.`name`, '}}'), `p`.`value`, ROW_NUMBER() OVER ()
FROM `templates` AS `t`
JOIN `parts` AS `p`
ON `t`.`value` LIKE CONCAT('%{{> ', `p`.`name`, '}}%')
WHERE `t`.`id` = 1
),
`result` (`value`, `order`) AS (
SELECT `value`, 0
FROM `templates`
WHERE `id` = 1
UNION SELECT REPLACE(`r`.`value`, `s`.`name`, `s`.`value`), `s`.`order`
FROM `result` AS `r`
JOIN `subs` AS `s`
ON `s`.`order` = `r`.`order` + 1
)
SELECT `value`
FROM `result`
ORDER BY `order` DESC
LIMIT 1WHERE `date_public` = (
SELECT MIN(`date_public`) FROM `events` WHERE `date_public` >= CURDATE()
)сheck_db = cursor.execute('SELECT * FROM identificator WHERE token = ?', (final_number,))check_db(final_number)
Ранее на php я использовал mysqli_fetch_arrayС вашим запросом и на PHP вернётся одна строка.
const mysql = require('mysql2/promise');
const conn = await mysql.createConnection({ ... });
const logins = ['marikas', 'tym', 'bars'];
async function main() {
const result = await conn.execute(
'SELECT login, cash FROM clients WHERE login in (?)',
[logins],
);
for ([login, cash] of result) {
console.log(login, cash);
}
}const mysql = require('mysql2');
const conn = mysql.createConnection({ ... });
const logins = ['marikas', 'tym', 'bars'];
function main() {
conn.execute(
'SELECT login, cash FROM clients WHERE login in (?)',
[logins],
(err, result) => {
if (err) {
throw new Error(err);
}
for ([login, cash] of result) {
console.log(login, cash);
}
},
);
}SELECT *
FROM (
SELECT *
FROM firm
LIMIT 10
OFFSET 0
) AS f
LEFT JOIN staff AS s ON s.fid = f.id