MySQL

MySQL Commands Cheat Sheet

January 20, 2021

Need a reference sheet for all the important MySQL commands? Check out this MySQL Commands article which includes a downloadable MySQL cheat sheet in PDF format.

Read more

How to Create a Table in MySQL

November 3, 2020

MySQL is a well-known, free and open-source database application. One of the most crucial processes in MySQL is creating tables and databases. Follow this tutorial to learn how to create a table in MySQL and insert data.

Read more

How to Create or Add an Index in MySQL With Examples

August 31, 2020

An index is an integral part of MySQL, helping with organizing and searching information more easily. This guide explains how to add an index to new and existing tables, as well as how you can display an existing index.

Read more

How to Drop a Table in MySQL

June 30, 2020

The DROP statement is a simple method to remove entire tables from your databases. It provides several versatile options that allow you to automate specific tasks. This tutorial also shows how to create a custom piece of code to remove tables based on character strings.

Read more

How to Import a CSV file into a MySQL database?

June 28, 2020

The article explains how to import a CSV file into a MySQL database using the command line or phpMyAdmin. Also, find out how to exclude the header row from the CSV and speed up the importation process.

Read more

How to Install and Configure MySQL on a Windows Server

April 23, 2020

The article provides many images that guide you through each individual step of a MySQL installation on Windows. The elaborate setup is made easy with clear instructions and concise descriptions of each particular option.

Read more

How to Export a Table from MySQL to CSV

April 3, 2020

This article explores several highly efficient methods that allow you to export a MySQL table as a CSV file. As a CSV file, the data from your tables becomes much more accessible, both to humans and a host of other applications.

Read more

How to Rename a Column in MySQL

March 30, 2020

This article offers two slick methods to rename a column in a MySQL table. Use ALTER TABLE command combined with the RENAME COLUMN clause for a swift resolution. The CHANGE clause offers more options and allows you to micromanage the renaming process.

Read more

How to Remove Duplicate Rows in MySQL

March 5, 2020

When adding data to a MySQL database, you may end up with duplicate rows. This article shows you how to find these instances and delete duplicate rows in MySQL. Create a test database, add data to it and practice identifying and removing duplicate rows.

Read more

How To Find Duplicate Values in MySQL

March 4, 2020

Learn how to find the duplicate entries in your MySQL databases. The guide shows you how to use the GROUP BY, COUNT() HAVING, and INNER JOIN functions to locate the duplicate entries.

Read more
© 2022 Copyright phoenixNAP | Global IT Services. All Rights Reserved.