![MySQL Shell Table Export Utility MySQL Shell Table Export Utility](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://objectstorage.us-ashburn-1.oraclecloud.com/n/idmqjyw9i2ib/b/blog/o/2024/mysql-shell-table-export/header.jpg)
We already discussed how we can use MySQL Shell to dump and load data using a multithreaded process. In this post, we will discuss ways we can export data from a table into different formats.
![RegEx Backreferences in MySQL RegEx Backreferences in MySQL](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://objectstorage.us-ashburn-1.oraclecloud.com/n/idmqjyw9i2ib/b/blog/o/2024/regex-back-references-mysql/header.jpg)
In my last regular expressions post, we discussed subexpressions and how to isolate specific parts of our pattern match. We can then use those subexpressions to replace parts of our pattern with other text. This post will discuss backreferences and how we can use them as part of our pattern match.
![Using RegEx Subexpressions in MySQL Using RegEx Subexpressions in MySQL](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://objectstorage.us-ashburn-1.oraclecloud.com/n/idmqjyw9i2ib/b/blog/o/2024/regex-subexpressions-mysql/header.jpg)
As I have discussed, regular expressions can be a powerful tool for developers. When we use regular expressions to match a pattern and need to replace part of that pattern, subexpressions make it much easier. Subexpressions are specific parts of a pattern that we can reference elsewhere in the process.
![A Different RegEx Solution A Different RegEx Solution](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://objectstorage.us-ashburn-1.oraclecloud.com/n/idmqjyw9i2ib/b/blog/o/2024/different-regex-solution/header.jpg)
In my last post about regular expressions (regex), I offered up a solution to requirements to extract text a substring from a larger blob of text. Over the weekend, I was thinking about this solution and wanted to know if it was possible to meet the requirements using a solution based solely on a regular expression. It turns out it is.
![More Regular Expressions in MySQL More Regular Expressions in MySQL](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://objectstorage.us-ashburn-1.oraclecloud.com/n/idmqjyw9i2ib/b/blog/o/2024/more-regular-expressions-mysql/header.jpg)
Regular expressions are used to match patterns in a given block of text. In a previous post, I discussed some regular expression features of MySQL. The examples I provided allowed us to return rows based on a pattern match and replace instances of our pattern with another substring. In this post, I will discuss some other regular expression functions.
![Hello, Adonis! Hello, Adonis!](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://objectstorage.us-ashburn-1.oraclecloud.com/n/idmqjyw9i2ib/b/blog/o/2024/hello-adonis/header.jpg)
For those who do not know me very well, I am an avid golfer. I have managed a local golf league for the last 15 years. During that time, the league has become so popular that we had to split the league in two and have half of the golfers play on Tuesday night and the other half on Thursday. Quite a few years ago, I wrote a web application to help me manage the league. The web app started showing its age, and I decided it was time to rewrite it from scratch. I also decided to bring you all along for the ride.
![MySQL Shell CLI Integration MySQL Shell CLI Integration](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://objectstorage.us-ashburn-1.oraclecloud.com/n/idmqjyw9i2ib/b/blog/o/2024/mysql-shell-cli-integration/header.jpg)
Over the last few years, I have become quite smitten with MySQL Shell. For those who may not be familiar with MySQL Shell, it is a new(ish) command line interface (CLI) for connecting to and managing MySQL instances. During a recent episode of Inside MySQL: Sakila Speaks, Fred and I talked to Miguel Araujo about many of the helpful (and lesser known) features of MySQL Shell. This post is the tenth in a series about these “hidden gem” features.
![Advanced Data Load with MySQL Shell Advanced Data Load with MySQL Shell](https://res.cloudinary.com/strozstuff/image/fetch/c_fit,w_250/https://objectstorage.us-ashburn-1.oraclecloud.com/n/idmqjyw9i2ib/b/blog/o/2024/data-load-mysql-shell/header.jpg)
Over the last few years, I have become quite smitten with MySQL Shell. For those who may not be familiar with MySQL Shell, it is a new(ish) command line interface (CLI) for connecting to and managing MySQL instances. During a recent episode of Inside MySQL: Sakila Speaks, Fred and I talked to Miguel Araujo about many of the helpful (and lesser known) features of MySQL Shell. This post is the ninth in a series about these “hidden gem” features.