MySQL Cheat Sheet
MySQL is a popular relational database management system (RDBMS) known for its performance and flexibility. This cheat sheet provides essential commands and queries for interacting with MySQL databases efficiently. Connecting…
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…
Backing up MySQL databases using mysqldump
mysqldump command is used to backup up MySQL databases. mysqldump has the following format: where is the file to which the backup should be written. Backing up specific tables By…
How to list MySQL tables using PHP
The following code lists all tables in a MySQL database:
Escaping string before inserting into MySQL
If a string contains a single quote, it will generate an error. mysqli->real_escape_string() escapes quotes for MySQL. See example:
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…
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…
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 becomes cumbersome. The easiest way to do this is to…
MySQL column enumeration example
Problem: You are building a database and you have a field that can accept only certain responses. For example, there is a Gender column which accepts only M or F…