How GENERATE_SERIES() Works in PostgreSQL

generate_series ( start timestamp with time zone, stop timestamp with time zone, step interval [, timezone text ] ). We can use a third argument to specify the step between each value in the series: SELECT * FROM generate_series( 1, 5, 2 )

Get a MySQL table structure from the INFORMATION_SCHEMA

SELECT * FROM db_name WHERE table_name LIKE '%Ф.И.О%'

Useful database analysis queries with INFORMATION_SCHEMA

SELECT USER, COUNT(*) FROM information_schema.PROCESSLIST GROUP BY USER. Finding duplicate indexes can explain a lot about how the designers or developers think the database should behave.

MySQL Как быстро посчитать все строки в таблице

Mysql select count(*) from information_schema.columns

MySQL - Difference between using count(*) and...

Генерация последовательности дат и generate_series... / Хабр

inurl index php db information schema as dbqt where 1902 1902 or...

Generate_Series() Equivalent in MySQL - ITCodar