This post only documents a simple program to show the effects of * and & in C and does not attempt to explain what pointers are. For a quick read, check out The 5-Minute Guide to C Pointers. Program: #include <stdio.h> int main() { // lval (left-hand side value – write) = rval (right-hand side …
The following query will list the top 5 tables by table size in MySQL. SELECT TABLE_SCHEMA, TABLE_NAME, CEIL((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS table_size_in_MiB, TABLE_ROWS AS estimated_row_count, AVG_ROW_LENGTH FROM information_schema.TABLES WHERE TABLE_SCHEMA NOT IN (‘information_schema’, ‘innodb’, ‘mysql’, ‘performance_schema’, ‘phpmyadmin’, ‘sys’, ‘tmp’) ORDER BY table_size_in_MiB DESC LIMIT 5; Note that TABLE_ROWS is only accurate …
