-- 10/23
tee 2024_10_23_sql_log.txt
use toyu

SELECT DISTINCT u.user, u.password
FROM mysql.user AS u
WHERE u.host = 'localhost'; 

SELECT DISTINCT u.host, u.user, u.password
FROM mysql.user AS u;

-- Getting selected columns from information_schema
SELECT table_name, table_type, row_format, table_rows, avg_row_length
FROM information_schema.tables
WHERE table_schema = 'information_schema'
ORDER BY table_name DESC;

SELECT table_name, table_type, row_format, table_rows, avg_row_length, create_time
FROM information_schema.tables
WHERE table_schema = 'toyu'
AND table_type = 'BASE TABLE'
ORDER BY table_name DESC;

-- databases and tables
SELECT t.TABLE_SCHEMA AS `schema`, COUNT(t.TABLE_NAME) AS num_tables
FROM information_schema.tables AS t
GROUP BY `schema`
ORDER BY num_tables DESC;

SELECT t.TABLE_SCHEMA AS `schema`, t.ENGINE, COUNT(t.TABLE_NAME) AS num_tables
FROM information_schema.tables t
GROUP BY `schema`, t.ENGINE
ORDER BY `schema`, num_tables DESC;

SELECT