Create a slug from a name in MySQL/MariaDB
If you need to generate URL-friendly slugs directly in MySQL or MariaDB — for example, turning “My Product Name” into …
Read Article →MySQL
42 articles about mysql development, tools, and best practices
How to Change a MariaDB/MySQL Data Directory to a New Location on Linux
Step 1 — Moving the MariaDB Data Directory
mysql -u root -p
select @@datadir;
Output:
+-----------------+
| @@datadir | …How to count the amount of rows in MariaDB fast
If you need to find the fastest way to count the number of rows in a massive MariaDB, or MySQL table, then you can do the following instead of …
Read Article →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 →How to Limit a MySQL Query 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.
How to Limit the …
Read Article →How to Update a MySQL Table 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.
How to Update a …
Read Article →How to Drop a MySQL Table 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.
How to …
Read Article →How to Delete MySQL Records 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.
How to Delete …
Read Article →How to ORDER BY a MySQL Query 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.
How to Sort the …
Read Article →How to Filter WHERE MySQL Queries 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.
How to Select …
Read Article →How to Select From MySQL 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.
How to Select …
Read Article →How to Insert into a MySQL Table in Python
If you need to insert data into a MySQL table using Python, then look no further.
If you need to first learn about the mysql.connector and how to get …
How to Create a Primary Key for a MySQL Database in Python
You can create a Primary Key for your MySQL database in Python as follows.
First, you need to know if the Primary Key already exists.
Option 1 – The …
Read Article →How to Create a MySQL Table in Python
If you need to create a table in a MySQL database using Python, then you can do the following.
How to Create a MySQL Table in Python
import …How to Create a MySQL Database in Python
In order to create a MySQL database in Python, you first need to initiate a connection using the mysql.connector. You can learn about how to create a …
How to Install MySQL Driver in Python
To begin using MySQL in Python, you need to do the following:
Step 1 – Install the MySQL Connector
Using pip, we can install the MySQL Connector …
How to move MySQL database to another drive
Step 1:
Login to your MySQL server, enter your password when prompted:
mysql -u root -p
Find out where the data directory is located:
mysql> select …[Solved] ERROR 1030 (HY000): Got error 168 from storage engine
If you are getting the following error in MySQL:
ERROR 1030 (HY000): Got error 168 from storage engine
Then this usually means that your server has …
Read Article →How to clone a table structure in MySQL
I have often needed to clone a table without it’s data in MySQL.
Oftentimes this has been because I have a continually growing temporary table …
Read Article →pt-online-schema-change Add Index
Percona has a great toolkit that allows you to perform schema changes on a MySQL or MariaDB database without any downtime, it works by creating a new …
Read Article →How To Create a User and Grant Permissions in MySQL
How to create a user
CREATE USER 'myuser'@'localhost' IDENTIFIED BY 'mypassword';
How to delete a user
DROP USER …Faster alternative to MySQL Delete Table Contents / Truncate
From time to time you might have some rather big tables that you want to delete all the data quickly and start afresh.
You have a few options at this …
Read Article →Moving a MySQL Database without downtime
At Statvoo Analytics we found ourselves in the position where we needed to move our master MySQL database without ANY downtime and for anyone …
Read Article →ORDER BY RAND() – Faster Alternative
MySQL’s ORDER BY RAND() function can be so useful for returning random items from a table, in fact, we have used it a million times over the …