mysql (38)

Exploring SQL's HAVING Clause for Advanced Filtering

When delving into SQL, mastering the HAVING clause alongside the GROUP BY statement becomes crucial for nuanced data manipulation. This feature empowers users to refine result sets post-grouping, particularly handy when dealing with aggregate functio...

Den W. · 01 April · 25

dbForge Studio for MySQL: Why I Switched to This Easy, All-Rounder GUI Tool

Learning MySQL introduced me to the command line interface and MySQL Workbench. While I find these tools enough for most tasks, I feel that my productivity is not good enough. So, I looked for another GUI tool and found dbForge Studio for MySQL. To m...

Edwin Sanchez · 29 August 2022 · 188

What is SQL Server: pros and cons of using

Databases are repositories that contain large amounts of information. You can send requests, receive information from them using DBMS - control systems. A popular DBMS developed by Microsoft is SQL Server. This program is available in several edition...

Alex · 27 July 2022 · 194

Best Free Database Management Software For Windows & Mac

A database refers to an electronic method of storing and organizing data. There are various types of databases, such as relational databases, hierarchical databases, object databases, network databases, graph databases, document databases, ER databas...

Alex · 29 April 2022 · 309

Database Weekly Digest. September 11, 2020

The CMU Database of Databases — An online encyclopedia of 714 (and counting) database systems, thanks to Carnegie Mellon University. We might have to spend some time going through this! It includes a leaderboard showing the most...

Alex · 11 September 2020 · 110

The Worst Typo I Ever Made

The “onosecond” is the second after you make a terrible mistake. The second when you realise what you just did and that there’s nothing you can do about it, the second when all the now-inevitable consequences flash through your mi...

Den W. · 01 June 2020 · 263

Tune Performance using MySQL Query EXPLAIN Plan

MySQL EXPLAIN plan helps you understand how MySQL queries are executed and what indexing techniques are better for running queries efficiently. The EXPLAIN plan is a handy statement, especially when you need to optimize MySQL queries. Everyone has e...

John Fuller · 6 days ago · 1

How to Add, Show, and Drop MySQL Foreign Keys

What is a foreign key in MySQL? We’ll start with the definition. A foreign key is a column or a group of columns that allow cross-referencing related data across tables in a database. A foreign key relationship comprises a parent table (that c...

John Fuller · 1 week ago · 1

Detailed comparison of phpMyAdmin and dbForge Studio for MySQL

phpMyAdmin is one of those go-to solutions that are always guaranteed to make it to nearly every list of top database tools dealing with the management and administration of MySQL and MariaDB databases. It is free, well-documented, and while limited...

John Fuller · 1 week ago · 1

How to grant and revoke privileges in MySQL

When it comes to keeping databases and data secure, it is recommended to use privileges. They can help you control who can access database data and do not allow users without specified permissions to view, modify, or delete database objects or data....

John Fuller · 25 April · 1

How to run a SQL script or file in MySQL & MariaDB

In database development, it is important to test the database with different data scenarios to ensure its functionality, performance, and reliability. Data import facilitates the population of test data sets, allowing developers to simulate real-worl...

John Fuller · 23 April · 1

TOP 10 IDEs for SQL Database Management & Administration [2024]

Modern organizations heavily rely on databases, with SQL databases being the predominant option. Daily workflows involve numerous database-related tasks, which database specialists must handle using specialized tools. Typically, it requires not just...

John Fuller · 15 April · 1

How to Remove Duplicate Rows in MySQL

Can it happen that the data stored in databases include identical records? Yes, it happens frequently. However, having duplicate records in databases is a scenario that should be avoided. Duplicates pose an ongoing risk to the data consistency and th...

John Fuller · 12 April · 1

How to Show Indexes in MySQL Tables & Database

Managing data from small or large databases is a daily task of database administrators and developers. Frequently, they need to search for specific data processing thousands of rows. This can be complicated with large databases and may lead to potent...

John Fuller · 09 April · 1

MySQL Temporary Tables

Temporary tables in MySQL are a special feature that allows users to store and manipulate temporary data within a specific session, thereby simplifying complex queries. It is a fast and convenient way to handle data without cluttering the database or...

John Fuller · 05 April · 1

Best alternative to SQLyog

SQLyog and dbForge Studio for MySQL are both viable solutions for database developers and administrators, with lots of nifty features hidden under clean user interfaces. But where SQLyog is a solid mid-tier player, dbForge Studio takes the art of dat...

John Fuller · 03 April · 1