Akina

UPDATE table 
SET value_column = REGEXP_REPLACE(value_column, '777\n?', '888');

SELECT *
FROM (
    SELECT toStartOfInterval(time_local, interval 3600 SECOND) AS interval,
           remote_addr,
           count(DISTINCT http_user_agent),
           count(http_user_agent)
    FROM accesslog.default
    WHERE time_local > (now() - toIntervalMinute(240))
    GROUP BY interval, remote_addr
    ORDER BY interval, remote_addr
    ) AS t1
INNER JOIN (
    SELECT *
    FROM accesslog.default
    WHERE time_local > (now() - toIntervalMinute(240))
    ) AS t2 ON t1.remote_addr=t2.remote_addr

CREATE TABLE log AS (
  WITH cte AS (
    SELECT STRING_TO_ARRAY(txt, ' ') parsed
    FROM t1
  )
  SELECT LEFT(parsed[2], 8) :: DATE dt,
         parsed[3] link,
         ARRAY_TO_STRING(parsed[6:100], ' ') agent,
         t2.city
  FROM cte
  LEFT JOIN t2 ON cte.parsed[1] = t2.ip
  );

SELECT *
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = DATABASE() /* либо 'database_name' */
  AND TABLE_NAME = 'table_name'

SELECT *
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'table_name'

Select * 
from Employees
where [Employee ID] != ALL ( SELECT 90 UNION SELECT NULL );

SELECT categories.id, 
       categories.slug,  
       ct_ru.title title_ru,  
       ct_en.title title_en,  
       ct_de.title title_de
FROM categories
LEFT JOIN category_translations ct_ru ON category_translations.category_id=categories.id 
                                     AND category_translations.locale = 'ru'
LEFT JOIN category_translations ct_en ON category_translations.category_id=categories.id 
                                     AND category_translations.locale = 'en'
LEFT JOIN category_translations ct_de ON category_translations.category_id=categories.id 
                                     AND category_translations.locale = 'de';