Select * to Show Database Table Sizes MariaDB
In database management, understanding the size of your tables is crucial for optimizing performance and ensuring efficient resource utilization. If …
Read Article →SQL
14 articles about sql development, tools, and best practices
Create a slug from a name in MySQL/MariaDB
How to create a slug from the name of an item in MySQL/MariaDB.
UPDATE my_table
SET slug = LOWER(REGEXP_REPLACE(REPLACE(REPLACE(REPLACE(name, ' …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.
Presenting the …
Read Article →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.
# use …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 server doesn’t …
Read Article →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 half of them were only 12 …
Read Article →Get the Second Highest Salary in MySQL
The problem
Write a SQL query to get the second highest salary from the Employee table.
For example, given the above Employee table, the query …
Read Article →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, it is located …
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 is easily achievable …
Read Article →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 …
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 …
Read Article →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 …
Read Article →