Database Queries⚓︎

SELECT table_schema "db-mysql-nyc1-79999",
        ROUND(SUM(data_length + index_length) / 1024 / 1024, 1) "DB Size in MB" 
FROM information_schema.tables 
GROUP BY table_schema;

SELECT
 tab.table_schema AS database_name,
 tab.table_name AS table_name,
 tab.table_rows AS table_rows
FROM
 information_schema.tables tab
 LEFT JOIN information_schema.table_constraints tco ON (tab.table_schema = tco.table_schema
   AND tab.table_name = tco.table_name
   AND tco.constraint_type = 'PRIMARY KEY')
WHERE
 tab.table_schema NOT IN('mysql', 'information_schema', 'performance_schema', 'sys')
 AND tco.constraint_type IS NULL
 AND tab.table_type = 'BASE TABLE';

UPDATE
 images
SET
 url = REPLACE(url, 'cdn.levine.io', 'cdn.levine.io')
WHERE
 url LIKE '%cdn.levine.io%';