Showing entries 11 to 20 of 135
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: mysql tools (reset)
How to Check MySQL Version

MySQL is an extremely popular open-source RDMS, and it is widely used by millions of companies and professionals. In this article, you will learn how to check the current MySQL version, and how to update it if necessary.

The post How to Check MySQL Version appeared first on Devart Blog.

How to Restore a MySQL Database with Command Line or Restore Tools

The article gives a deep insight into how to restore MySQL database from a backup file using the mysqldump utility and third-party backup and restore tools, such as dbForge Studio for MySQL, MySQL Workbench, and phpMyAdmin.

The post How to Restore a MySQL Database with Command Line or Restore Tools appeared first on Devart Blog.

How to Enable, Configure, and Use MySQL Query Logging

In this article, we will address questions such as the purpose of query logging in MySQL, why it is important, how to enable and configure it, and more. You’ll find a detailed guide on how to use mysqldumpslow to analyze slow query logs, along with tips on harnessing convenient GUI tools like dbForge Studio for MySQL to your advantage.

The post How to Enable, Configure, and Use MySQL Query Logging appeared first on Devart Blog.

Time to Empower Yourself With the Newly Updated dbForge Tools for MySQL 10.1

There's nothing quite like delivering regular feature-packed updates to our dear users—and we've got one for you today. dbForge tools for MySQL have been updated to version 10.1 with extended connectivity and quite a few new tricks to make your work easier and faster. To top it off, you get convenient CLI-powered generation of comparison reports.

The post Time to Empower Yourself With the Newly Updated dbForge Tools for MySQL 10.1 appeared first on Devart Blog.

MySQL INT (INTEGER) Data Types with Different Examples

This article explains the SIGNED and UNSIGNED integer data types in MySQL and provides examples to illustrate when and how to use these integer data types effectively.

The post MySQL INT (INTEGER) Data Types with Different Examples appeared first on Devart Blog.

MySQL INSERT Statement – Inserting Rows Into a Table

The article covers the basic syntax of the MySQL INSERT statement and explains how to work with the INSERT command in the MySQL table using dbForge Studio for MySQL.

The post MySQL INSERT Statement – Inserting Rows Into a Table appeared first on Devart Blog.

MySQL CLI (Command-Line Interface): How to Get Started With MySQL Database Management

The article provides a detailed guide on MySQL Command Line Client and shares useful tips on how to download, install, and get started with it. Read the tutorial to find out the best MySQL client on the market today.

The post MySQL CLI (Command-Line Interface): How to Get Started With MySQL Database Management appeared first on Devart Blog.

MySQL Performance Monitoring Tools and the Most Important Metrics to Monitor

This article covers some of the most popular MySQL performance monitoring tools alongside the key performance metrics that can help improve and optimize query performance in MySQL databases.

The post MySQL Performance Monitoring Tools and the Most Important Metrics to Monitor appeared first on Devart Blog.

MySQL String Functions in Action

MySQL has a set of built-in functions for data processing, transformation, and analysis. In particular, the following discussion will be about string functions. So, let's find out what they are and when to use them.

The post MySQL String Functions in Action appeared first on Devart Blog.

How to Add, Show, and Drop MySQL Foreign Keys

A key is typically defined as a column or a group of columns that are used to uniquely locate table records in relational databases (including MySQL, of course). And now that we've covered MySQL primary keys on our blog, it's time to give you a similarly handy guide on foreign keys.

The post How to Add, Show, and Drop MySQL Foreign Keys appeared first on Devart Blog.

Showing entries 11 to 20 of 135
« 10 Newer Entries | 10 Older Entries »