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 →14 articles about sql development, tools, and best practices
In database management, understanding the size of your tables is crucial for optimizing performance and ensuring efficient resource utilization. If …
Read Article →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, ' …
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.
The below Python code will create a connection to a MSSQLServer instance, and retrieve data from it back into a variable called tblResults
.
# use …
Read Article →
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 →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 →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 →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 …
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 →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 …
SQL (Structured Query Language) for relational databases was maintained and standardised by the American National Standards Institute (ANSI) and the …!-->
Read Article →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 →