mysqlgui (13)

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 · 189

MySQL Full-Text Search

MySQL full-text search is a powerful tool for effectively seeking data in databases. It allows creating complete text indexes that simplify search query performance. It's relevant while working with textual content, especially when you need to quickl...

John Fuller · 2 days ago · 1

How to Kill Running Process, Query, or Session in MySQL

Every database developer and administrator strives to maintain optimal performance and stability for their databases. There are tasks that need to be done every single day to keep things the way they should be. Let us explore how to manage MySQL proc...

John Fuller · 4 days ago · 1

Best Navicat alternative for MySQL and MariaDB databases

Navicat is a popular brand of GUI tools that help handle a number of tasks related to database development and management. Moreover, these tools work across a wide variety of the world's biggest relational database systems, including, among others, M...

John Fuller · 5 days ago · 1

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 · 1 week 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 · 2 weeks 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 · 2 weeks ago · 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

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

How to import text files to MySQL/MariaDB databases

Data import is one of the basic yet important operations in database management. What you need here is a selection of formats to choose from, flexible settings for each format, and a handy GUI tool that will help you make the process smooth and effic...

John Fuller · 18 March · 1

How to import Google Sheets to MySQL or MariaDB

Effective data export and import form the backbone of robust database management. Whether you are creating regular backups for data security or facilitating seamless database migration to a new server, the import process plays a pivotal role. Additio...

John Fuller · 07 March · 1

MySQL UPSERT: Comprehensive Examples and Use Cases

Storing data in databases inherently requires regular updates. This process involves adding new data and replacing outdated information. While numerous challenges are associated with updating data in databases, this article will concentrate on a spec...

John Fuller · 03 January · 7