MySQL: CAST any Data Type as INTEGER

To CAST any data type to Integer in MySQL, you need to CAST it as SIGNED (for getting a signed integer) or UNSIGNED (for getting unsigned integer).

MySQL: Check Database and Table Size

This process will work in all cases, whether you are accessing your database through the command line or using any GUI tool (like MySQL Workbench or HeidiSQL). Because the size-related information is already saved in a specific MySQL table. Check the table named “TABLES” from the database “information_schema”, you will find all the information related to the sizes of the tables.