---
title: "#mysql-guide articles | Hashnode"
description: "Explore 4 articles tagged #mysql-guide on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/mysql-guide"
---

Tag

# #mysql-guide

4 posts · 0 followers

[Jamey Barton](https://hashnode.com/@DBAJamey) · [Nov 13, 2025](https://hashnode.com/posts/list-mysql-databases-how-to-use-the-show-databases-command/6915b524b631b952b85260ec)

### [List MySQL Databases: How to Use the SHOW DATABASES Command](https://dbajamey.hashnode.dev/list-mysql-databases-how-to-use-the-show-databases-command?utm_source=hashnode&utm_medium=feed)

Getting a list of MySQL databases that reside on a server may come in handy for various reasons. For example, developers will use it to explore the current environment, and DBAs will need it to carry out routine server maintenance. In this article, ...

1 min read · [dbajamey.hashnode.dev](https://dbajamey.hashnode.dev/list-mysql-databases-how-to-use-the-show-databases-command?utm_source=hashnode&utm_medium=feed)

[Jamey Barton](https://hashnode.com/@DBAJamey) · [Oct 24, 2025](https://hashnode.com/posts/mysql-replace-function-syntax-and-examples/68fb402d712e3691c80d5d7e)

### [MySQL REPLACE Function: Syntax and Examples](https://dbajamey.hashnode.dev/mysql-replace-function-syntax-and-examples?utm_source=hashnode&utm_medium=feed)

When teams deal with large volumes of messy data, fixing errors row by row isn’t an option. That’s where the REPLACE function becomes indispensable. It lets developers update typos, obsolete values, or even entire product lines much faster. This art...

1 min read · [dbajamey.hashnode.dev](https://dbajamey.hashnode.dev/mysql-replace-function-syntax-and-examples?utm_source=hashnode&utm_medium=feed)

[Jamey Barton](https://hashnode.com/@DBAJamey) · [Oct 23, 2025](https://hashnode.com/posts/the-hidden-power-and-risk-of-mysql-cross-join/68fa222f676d7a183b9a03f1)

### [The Hidden Power (and Risk) of MySQL CROSS JOIN](https://dbajamey.hashnode.dev/the-hidden-power-and-risk-of-mysql-cross-join?utm_source=hashnode&utm_medium=feed)

Most JOINs filter and refine. A MySQL CROSS JOIN does the opposite. It produces a Cartesian product, generating every possible row combination between two tables. That makes it ideal for modeling permutations, scheduling, or building complete matrice...

1 min read · [dbajamey.hashnode.dev](https://dbajamey.hashnode.dev/the-hidden-power-and-risk-of-mysql-cross-join?utm_source=hashnode&utm_medium=feed)

[Jamey Barton](https://hashnode.com/@DBAJamey) · [Jun 19, 2025](https://hashnode.com/posts/aggregate-functions-in-mysql-what-they-are-examples-and-best-practices/6853e94b2c7ce2a812b69f96)

### [Aggregate Functions in MySQL: What They Are, Examples, and Best Practices](https://dbajamey.hashnode.dev/aggregate-functions-in-mysql-what-they-are-examples-and-best-practices?utm_source=hashnode&utm_medium=feed)

For developers, analysts, and database professionals working with MySQL, mastering aggregate functions is non-negotiable. A comprehensive guide published by Devart provides a thorough breakdown of how to use COUNT(), SUM(), AVG(), MIN(), and MAX() to...

1 min read · [dbajamey.hashnode.dev](https://dbajamey.hashnode.dev/aggregate-functions-in-mysql-what-they-are-examples-and-best-practices?utm_source=hashnode&utm_medium=feed)