How to Join Multiple MySQL Tables in Python
First, you will need the mysql.connector. If you are unsure of how to get this setup, refer to How to Install MySQL Driver in Python.… Read More »How to Join Multiple MySQL Tables in Python
SQL
Retrieve records from MSSQLServer in Python
The below Python code will create a connection to a MSSQLServer instance, and retrieve data from it back into a variable called tblResults.
How to Abort SQL statements after a set time in MariaDB
Sometimes you don’t want a SELECT query to run for more than a set amount of time. This is a roundabout way to make your… Read More »How to Abort SQL statements after a set time in MariaDB
SQL to Append all Fields if Shorter than a set Length
This came in very handy for me at one point because I needed to have a certain field in each row 14 characters long, but… Read More »SQL to Append all Fields if Shorter than a set Length
Get the Second Highest Salary in MySQL
The problem Write a SQL query to get the second highest salary from the Employee table. +—-+——–+ | Id | Salary | +—-+——–+ | 1 | 100… Read More »Get the Second Highest Salary in MySQL
How to Purge the BinLog for MySQL and MariaDB
If you see lots of disk space quickly disappearing on your MySQL or MariaDB server, then you may want to look into the BinLog directory,… Read More »How to Purge the BinLog for MySQL and MariaDB
How to Delete from a Table where rows match in Another Table – MySQL
So you have a table where you want to delete a bunch of rows, based on a particular column being matched in another table. This… Read More »How to Delete from a Table where rows match in Another Table – MySQL
REPLACE INTO instead of INSERT INTO – MySQL
There are many occasions where you need to INSERT a record into a MySQL database table, but the record already exists. INSERT INTO queue_domains (domain)… Read More »REPLACE INTO instead of INSERT INTO – MySQL
A bit on SQL Standards
SQL (Structured Query Language) for relational databases was maintained and standardised by the American National Standards Institute (ANSI) and the International Organisation for Standardisation (ISO)… Read More »A bit on SQL Standards
Why we don’t choose MSSQL!
Everybody always raves how great Microsoft SQL Server is, and how much data it can hold, and how much bigger it’s “package” is than your… Read More »Why we don’t choose MSSQL!
Error 29506 while installing SQL Server Management Studio Express
I was trying to install Microsoft SQL Server Management Studio Express (what a long name) on a machine and kept getting error 29506 right near… Read More »Error 29506 while installing SQL Server Management Studio Express