MySQL (MySQL Inspired Databases, Including MariaDB)
How to Optimize MySQL Queries for Speed and Performance
A great article on how to optimize MySQL queries: How to Optimize MySQL Queries for Speed and Performance
...
How to Combine Data From Multiple Rows into One Field using MySQL [GROUP_CONCAT]
SELECT post_id, GROUP_CONCAT(meta_value) as full FROM wp_postmeta WHERE (meta_key = 'isc_image_source' or meta_key = 'isc_image_source_url') GROUP BY...
MySQL: How to Find Slow Queries & Optimize Them
Let's see if you have "slow_query_log" enabled -- issue the following command:
show global variables like '%slow%';
If "slow_query_log" is set to...
How to Import and Export MySQL Database(s)
Export a Database
$ sudo mysqldump -u username -p dbname > dbexport.sql
Export Table from a Database into a File
> select * from wp_posts...
How to Rename a MySQL Database
You can't rename a database directly. It's a four-step process.
mysql -u username -p -e "CREATE DATABASE new_dbname"mysqldump -u username -p old_dbname...
How to Search Your Entire MySQL Database for a Phrase
I tested the following command on an Ubuntu v18.04 virtual private server (VPS).
$ sudo mysqldump -u <username> --no-create-info --extended-insert=FALSE...
12 Important MySQL Commands You Should Know
MySQL is the world's most widely used relational database management system (RDMS), maintaining greater than 40% market penetration and leveraged by a...