Code Scraps: Finding duplicate records in MySQL
This is a quick code scrap to illustrate how to identify duplicate field values in record sets in MySQL. The code may also work for other SQL languages, but do […]
MySQL
Code Scraps: Retrieve all tables in a SQL Server database
MySQL has a really useful command called SHOW TABLES. It lists you all the tables available in the connected database. Unfortunately Microsoft SQL Server doesn’t have such a useful shorthand […]
Programmatically storing your Database for Source Control
Databases are often a critical part of most applications today. But how do you go about storing them for Source Control purposes? There are a number of approaches – the […]
Code Scraps: Hide system MySQL databases from phpMyAdmin listings
Here’s a quick code scrap to hide the system MySQL and phpMyAdmin databases from being listed within the web application itself. Open your phpMyAdmin’s config.ini.php file and locate the end […]
Forgotten your MySQL root password? No problem!
I recently forgot the root password to a MySQL instance on one of my machines. Follow this quick and easy guide for whenever this happens to you. Stop MySQL sudo […]