Рецепты для хворающих SQL-запросов / Хабр

MySQL Functional Indexes | dasini.net - Diary of a MySQL expert

mysql> SELECT INDEX_NAME, EXPRESSION. From information_schema.statistics. Discovering MySQL Database Service – Episode 10 – Connect to MySQL Database Service Using OCI Cloud Shell.

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

Mysql select count(*) from information_schema.columns

SQL SELECT Statement

Useful database analysis queries with INFORMATION_SCHEMA

SELECT * FROM information_schema.PROCESSLIST WHERE COMMAND != Finding duplicate indexes can explain a lot about how the designers or developers think the database should behave.

inurl index php db information schema'""'') as efat where 8605...

INFORMATION_SCHEMA.TABLES or INFORMATION_SCHEMA.COLUMNS work for only specified databases. The database schema of a database system is its structure described in a formal language supported by the database management system (DBMS).

SQL COUNT() Функция — schoolsw3.com

COUNT(*) / Хабр

Get a MySQL table structure from the INFORMATION_SCHEMA

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

How to see indexes for a database or table in... | Gang of Coders

SELECT DISTINCT TABLE_NAME, INDEX_NAME FROM INFORMATION_SCHEMA.STATISTICS WHERE TABLE_SCHEMA = 'your_schema' You can specify the database name if you are not connected to any database or you want to get the index information of a table in a different database

SQL-запросы: гайд по основным командам... / Skillbox Media

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

SQL - Урок 4. Выборка данных - оператор SELECT