How to empty a MySQL database
Emptying a databases involves dropping (deleting) all its tables. The easiest way to do this is to drop and recreate…
Python3 with MySQL database
If you don’t already have MySQL installed, install it with the following commands (mac only): Run the following commands to…
Character sets, encoding, and collation in MySQL
Character: set of symbols and encodings Encoding: set of values assigned to characters Collation: set of rule for comparing a character set Suppose you have…
Listing all tables and their table counts in a MySQL database
The Following SQL query will list all tables in a MySQL database and also list the row counts for each.…