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...
29 August 2022
·
4
· 195
·
Edwin Sanchez
MySQL Select Database
Chances are that you have multiple databases on the MySQL Server instance you're connected to; and when you need to manage several databases at once, you need to make sure you have selected the correc...
17 June
·
0
· 2
·
John Fuller
How to list the users in a MySQL/MariaDB database and Manage Permissions
User management involves granting database access, setting user permissions, and monitoring activities. This process, traditionally handled via command-line utilities, includes creating, modifying, an...
30 May
·
0
· 2
·
John Fuller
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...
22 May
·
0
· 1
·
John Fuller
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 relat...
21 May
·
0
· 1
·
John Fuller
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 y...
14 May
·
0
· 1
·
John Fuller
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...
12 May
·
0
· 1
·
John Fuller
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 p...
12 April 2024
·
0
· 8
·
John Fuller
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 compl...
09 April 2024
·
0
· 1
·
John Fuller
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 mi...
03 April 2024
·
0
· 1
·
John Fuller
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 th...
18 March 2024
·
0
· 1
·
John Fuller
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...
07 March 2024
·
0
· 1
·
John Fuller
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...
03 January 2024
·
0
· 7
·
John Fuller
