Showing entries 1 to 10 of 58
10 Older Entries »
Displaying posts with tag: How To (reset)
WHERE Condition in MySQL with 16 Different Query Examples

In this article, we are going to talk about the WHERE clause and how to use it in MySQL. Besides SELECT, the scope of the WHERE clause includes the UPDATE and DELETE statements. The WHERE clause is indispensable for quality work with MySQL databases. That’s why the current article will deal with this clause and […]

The post WHERE Condition in MySQL with 16 Different Query Examples 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. Contents What is a MySQL client? What is the difference between MySQL Server and MySQL client? […]

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

Check Your Current MySQL Version in 6 Ways

MySQL is an extremely popular open-source RDMS, and it’s 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. Contents Why do you need to know your MySQL version? Different ways how to get your MySQL version […]

The post Check Your Current MySQL Version in 6 Ways appeared first on Devart Blog.

InnoDB vs MyISAM: A Detailed Comparison of Two MySQL Storage Engines

If you are looking to improve the performance of MySQL databases in your software, you may need to know all the differences between InnoDB and MyISAM, two well-known types of MySQL storage engines. And if you are about to choose one of them, we believe you would like to find out what each of them […]

The post InnoDB vs MyISAM: A Detailed Comparison of Two MySQL Storage Engines 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. Contents Use the mysql command to restore a database from the command line Create the database Restore the database […]

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

Different Ways to Back up MySQL Databases and Tables

The article provides an overview of the backup types available in MySQL and describes how-to examples of using the mysqldump command-line utility to take a backup of the database, tables, data, or schema and to restore the MySQL database. In addition, you can view how to generate a database backup with MySQL Workbench and how […]

The post Different Ways to Back up MySQL Databases and Tables appeared first on Devart Blog.

How to Connect to MySQL Server Databases Remotely

Distributed environment is hardly a new notion in the world of software. For one, you no longer need to host MySQL servers and databases on the same local machine. Now you can have a dedicated server that can deliver the required level of security and performance. With the help of root/sudo user privileges, you can […]

The post How to Connect to MySQL Server Databases Remotely appeared first on Devart Blog.

How to Rename a Table in MySQL in Different Ways

The article explores a bunch of popular methods to rename a MySQL table and provides handy worked examples that could be of utility to both beginning and experienced users. In one of our previous articles, we looked in detail at how to rename a database in MySQL. In this article, we are going to focus […]

The post How to Rename a Table in MySQL in Different Ways appeared first on Devart Blog.

What Is InnoDB in MySQL? Tutorial with Examples and Performance Tuning Tips

There is a number of powerful MySQL storage engines at our disposal, and InnoDB is undoubtedly one of the most popular ones. It is highly reliable and efficient, so it is no wonder that it has become a default storage engine for all MySQL versions from 5.5 on. Let us take a look at its […]

The post What Is InnoDB in MySQL? Tutorial with Examples and Performance Tuning Tips appeared first on Devart Blog.

How to Create a View in MySQL

This article will show you how to create and manage views in MySQL. A view is a virtual table that does not store its own data but rather displays data that is stored in other tables. Essentially, a view is a result of SQL query execution, which returns the required rows of data from one […]

The post How to Create a View in MySQL appeared first on Devart Blog.

Showing entries 1 to 10 of 58
10 Older Entries »