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…
NoSQL Overview
NoSQL is not one technology. It refers to a wide variety of different database technologies that address scale and agility challenges of today’s applications. These problems include: agile development where…
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:
Quick introduction to MongoDB
MongoDB is document based NoSQL database. This means that: it has no schema it has no relations it is agile and scaleable stores information in nested documents of two-dimensional key/value…
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…
Database normalization and normal forms
The goal of database normalization is to reduce data redundancy and to improve data integrity. This is done by organizing columns and tables by apply the normal forms. In theoretical…