-- SQL workarea

-- 3/26

tee 2025_3_26_sql_log.txt

desc information_schema.INNODB_SYS_FOREIGN_COLS;

SELECT inf.* 
FROM information_schema.REFERENTIAL_CONSTRAINTS AS inf
WHERE inf.CONSTRAINT_SCHEMA = 'toyu';







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


-- 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
FROM information_schema.tables
WHERE table_schema = 'toyu'
ORDER BY table_name ASC;

SELECT COUNT(*) AS `# RC`
FROM information_schema.Referential_constraints AS IRC
WHERE IRC.constraint_schema = 'toyu';

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;