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.…
How to empty a MySQL database
Emptying a databases involves dropping (deleting) all its tables. If you have a hundred tables in your database, the task…
MySQL column enumeration example
Problem: You are building a database and you have a field that can accept only certain responses. For example, there…
How to setup virtual lamp stack on Microsoft Windows
Oracle’s VirtualBox is a very solid and stable virtual machine but it isn’t the simplest to work with. So I…
Quick Introduction to JSON
JavaScript Object Notation (JSON) is a lightweight standard for data interchange. It offers several advantages over XML for data interchange…
Copying a large database from one server to another
Recently, I had to copy a large database from one server to another. I had 100G free on the source…
Finding duplicate values in a MySQL database
In the following query, we list all lastname held by 2 or more employees. If you want a value to…