mariadb
(18)
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 day 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 · 3 days 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 · 6 days 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
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
How to Install Windows on a Mac With Parallels and Run dbForge Edge
dbForge Edge is an expansive solution that covers a huge number of database-related tasks across multiple database systems and cloud services, including MySQL, MariaDB, Microsoft SQL Server, Oracle Database, and PostgreSQL. And though dbForge Ed...
John Fuller · 28 March · 3
Export MySQL data to CSV: Comprehensive tutorial & best practices
CSV is one of the most versatile data formats that is widely used to exchange structured data between different applications. The convenience of CSV lies in simplicity. CSV files contain plain text that can be opened by any text editing app, such as...
John Fuller · 25 March · 1
How to Change a Column Type in MySQL
MySQL is well-known among other relational database management systems for its robustness and versatility. A fundamental aspect of its architecture lies in the meticulous handling of data types within columns, a crucial element determining the nature...
John Fuller · 20 March · 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
Connect to RDS MySQL 101: Your Easy Guide on How to Banish Glitches
Have you ever been stuck in MySQL connectivity chaos? Wondering how to connect to RDS MySQL without summoning gremlins? Fret not – you’re not alone. In the realm of database setup, glitches can be as stubborn as a cat refusing to leave a...
John Fuller · 15 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
Migrate MySQL Database to Any Target: How to Do It Quick and Easy
How unnerving is it to migrate a MySQL database to another location? If you did it before, how does it feel after the migration? Is it like you were dropped in a war-torn place? Explosions here and there? Guns blazing? With all the screaming, trauma...
John Fuller · 01 February · 1