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 a database: Depending on the system you are working, the…
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 start or stop mysql. Start MySQL before proceeding: To see…
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 the following characters, that are assigned the following values: sequentially.…
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. where mydatabase is the name or your database. The output…