--- title: "#mysql-ide articles | Hashnode" description: "Explore 11 articles tagged #mysql-ide on Hashnode. Tutorials, guides, and how-tos from the community." url: "https://hashnode.com/tag/mysql-ide" --- Tag # #mysql-ide 11 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 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) [Gabriella Barajas](https://hashnode.com/@gabbbybar) · [Jul 10, 2025](https://hashnode.com/posts/query-run-fast-from-mysql-cli-but-very-slow-on-r2dbctemplate-code/686fbb9e2c7602aed7687aaa) ### [Query run fast from MySQL CLI but very slow on R2dbcTemplate Code](https://databasedev.hashnode.dev/query-run-fast-from-mysql-cli-but-very-slow-on-r2dbctemplate-code?utm_source=hashnode&utm_medium=feed) Question: Currently, I having a query SELECT al.category, IFNULL(jt.name, 'Ungrouped Devices') AS device\_group\_name, IFNULL(jt.id, '00000000-0000-0000-0000-000000000000') AS device\_group\_id, jt.color\_code AS color\_code, COUNT(\*) AS total FR... 3 min read · [databasedev.hashnode.dev](https://databasedev.hashnode.dev/query-run-fast-from-mysql-cli-but-very-slow-on-r2dbctemplate-code?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) [Jamey Barton](https://hashnode.com/@DBAJamey) · [Jun 16, 2025](https://hashnode.com/posts/best-multi-database-ides-for-2025-a-strategic-leaders-guide/68501b6417f97e930200e8aa) ### [Best Multi-Database IDEs (MySQL, PostgreSQL, Oracle, SQL Server) for 2025: A Strategic Leader’s Guide](https://dbajamey.hashnode.dev/best-multi-database-ides-for-2025-a-strategic-leaders-guide?utm_source=hashnode&utm_medium=feed) Explore the top multi-database IDEs of 2025 designed for MySQL, PostgreSQL, Oracle, and SQL Server. Make confident decisions that align with your strategy.. 4 min read · [dbajamey.hashnode.dev](https://dbajamey.hashnode.dev/best-multi-database-ides-for-2025-a-strategic-leaders-guide?utm_source=hashnode&utm_medium=feed) [Jamey Barton](https://hashnode.com/@DBAJamey) · [May 13, 2025](https://hashnode.com/posts/mysql-subqueries-guide/68233a9f8fe9487592ab21f2) ### [MySQL Subqueries Guide](https://dbajamey.hashnode.dev/mysql-subqueries-guide?utm_source=hashnode&utm_medium=feed) Subqueries in MySQL are very useful when data manipulation gets complicated. MySQL is among the most powerful and widely used relational databases. Still, retrieving the exact data you need can quickly become challenging, especially if it involves mu... 1 min read · [dbajamey.hashnode.dev](https://dbajamey.hashnode.dev/mysql-subqueries-guide?utm_source=hashnode&utm_medium=feed) [Jamey Barton](https://hashnode.com/@DBAJamey) · [Dec 11, 2024](https://hashnode.com/posts/how-to-rename-a-mysql-database/6759a457b84a103458d9ed56) ### [How to Rename a MySQL Database](https://dbajamey.hashnode.dev/how-to-rename-a-mysql-database?utm_source=hashnode&utm_medium=feed) When working with MySQL databases, you may encounter the need to change a database name. However, MySQL no longer supports a direct renaming option. The RENAME DATABASE command, available in earlier versions, was removed due to the risk of data loss.... 1 min read · [dbajamey.hashnode.dev](https://dbajamey.hashnode.dev/how-to-rename-a-mysql-database?utm_source=hashnode&utm_medium=feed) [Jamey Barton](https://hashnode.com/@DBAJamey) · [Nov 28, 2024](https://hashnode.com/posts/explore-the-power-of-dbforge-tools-for-mysql-and-mariadb/674886f9963a496491aa4d34) ### [Explore the Power of dbForge Tools for MySQL and MariaDB](https://dbajamey.hashnode.dev/explore-the-power-of-dbforge-tools-for-mysql-and-mariadb?utm_source=hashnode&utm_medium=feed) If you're working with MySQL or MariaDB, having the right tools for development and administration can make all the difference. Designed for database developers, architects, DBA, analysts, DevOps and other database professionals who demand efficiency... 2 min read · [dbajamey.hashnode.dev](https://dbajamey.hashnode.dev/explore-the-power-of-dbforge-tools-for-mysql-and-mariadb?utm_source=hashnode&utm_medium=feed) [Jamey Barton](https://hashnode.com/@DBAJamey) · [Nov 12, 2024](https://hashnode.com/posts/how-to-restore-a-mysql-database-with-command-line-or-restore-tools/67335666e4306aad1b7b9f2e) ### [How to Restore a MySQL Database with Command Line or Restore Tools](https://dbajamey.hashnode.dev/how-to-restore-a-mysql-database-with-command-line-or-restore-tools?utm_source=hashnode&utm_medium=feed) There may be situations when data gets lost or corrupted, for example, when users accidentally deleted or overwrote data. For these reasons, it is recommended to make a backup on a regular basis. Through this process, you can ensure data consistency ... 1 min read · [dbajamey.hashnode.dev](https://dbajamey.hashnode.dev/how-to-restore-a-mysql-database-with-command-line-or-restore-tools?utm_source=hashnode&utm_medium=feed) [Jamey Barton](https://hashnode.com/@DBAJamey) · [Oct 17, 2024](https://hashnode.com/posts/how-to-enable-configure-and-use-mysql-query-logging/6710dbb67df2abe21f182908) ### [How to Enable, Configure, and Use MySQL Query Logging](https://dbajamey.hashnode.dev/how-to-enable-configure-and-use-mysql-query-logging?utm_source=hashnode&utm_medium=feed) What is the purpose of query logging in MySQL? Why is it important? How do you enable and configure it? This article addresses these questions and more. You will find a detailed guide on how to use mysqldumpslow to analyze slow query logs, along with... 1 min read · [dbajamey.hashnode.dev](https://dbajamey.hashnode.dev/how-to-enable-configure-and-use-mysql-query-logging?utm_source=hashnode&utm_medium=feed)