SQL

Home /
Tags /
SQL

Select * to Show Database Table Sizes MariaDB

December 21, 2023

In database management, understanding the size of your tables is crucial for optimizing performance and ensuring efficient resource utilization.

Create a slug from a name in MySQL/MariaDB

August 25, 2023

SQL , My SQL

How to create a slug from the name of an item in MySQL/MariaDB.

How to Join Multiple MySQL Tables in Python

August 9, 2022

My SQL , Python , SQL

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 .

Retrieve records from MSSQLServer in Python

August 2, 2021

Python , SQL

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

July 17, 2021

Sometimes you don’t want a SELECT query to run for more than a set amount of time.

SQL to Append all Fields if Shorter than a set Length

June 8, 2020

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 half of them were only 12 characters long.

Get the Second Highest Salary in MySQL

June 1, 2020

The problem Write a SQL query to get the second highest salary from the Employee table.

How to Purge the BinLog for MySQL and MariaDB

March 27, 2020

My SQL , SQL

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, it is located at /var/log/mysql/.

How to Delete from a Table where rows match in Another Table – MySQL

March 24, 2020

My SQL , SQL

So you have a table where you want to delete a bunch of rows, based on a particular column being matched in another table.

REPLACE INTO instead of INSERT INTO – MySQL

March 23, 2020

My SQL , SQL

There are many occasions where you need to INSERT a record into a MySQL database table, but the record already exists.

A bit on SQL Standards

November 12, 2017

Databases , SQL

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) which is affiliated with the International Electrotechnical Commission (IEC).

Why we don’t choose MSSQL!

May 26, 2010

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 own.

Error 29506 while installing SQL Server Management Studio Express

April 28, 2010

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 the end with a Rollback action thereafter.