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]1.
Presenting …
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]1.
How to Limit …
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]1.
How to Update …
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]1.
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]1.
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]1.
How to Sort …
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]1.
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]1.
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 …