mysql Archives – {coding}Sight

A Quick Guide on Installing MySQL on Ubuntu

February 18, 2021February 18, 2021 Nisarg Upadhyay Leave a comment

Total: 0 Average: 0

This article will present the step-by-step installation process of the MySQL server on Ubuntu. For demonstration purposes, I created a virtual machine using Oracle VM virtual box and set up Ubuntu 18.04 on the virtual box. I’d recommend you referring to the article Creating a Virtual Machine with Oracle VM Virtual Box for a better understanding of the installing process and creating a virtual machine on Oracle VM virtual box. Also, you may turn to the article How to Install Ubuntu 18.04 for more information about installing Ubuntu 18.04 on the virtual machine.

Backup and Restore MySQL Database Using mysqldump

February 17, 2021February 18, 2021 Nisarg Upadhyay Leave a comment

Total: 0 Average: 0

The current article focuses on applying the mysqldump utility to backup and restore MySQL databases. This utility is the most common tool for generating backups in several formats or restoring MySQL databases.

Understanding the Process of an Azure Database Deployment on MySQL

February 17, 2021February 18, 2021 Nisarg Upadhyay Leave a comment

Total: 0 Average: 0

This article describes the step-by-step deployment process of the Azure Database for MySQL Server.

Open the Azure portal and log in using the appropriate credentials. Note: For demonstration purposes, I got a pay-as-you-go subscription to Microsoft Azure. For more information about the Azure price model and various Azure subscriptions, refer to Subscriptions, licenses, accounts, and tenants for Microsoft’s cloud offerings.

The Top 5 Facts About MySQL INSERT for T-SQL Developers

February 16, 2021February 17, 2021 Edwin Sanchez Leave a comment

Total: 0 Average: 0

Developers are lifelong students. Gaining new knowledge as fast as we can is always our gig. If you’re coming from the T-SQL camp, what’s the faster way to learn MySQL? Often you want to compare syntaxes. Last time, you learned about creating a table in MySQL. Our today’s post will take you a step further. We’ll insert records with MySQL INSERT.

Install and Configure ODBC Drivers for MySQL

February 16, 2021February 18, 2021 Nisarg Upadhyay Leave a comment

Total: 0 Average: 0

This article focuses on the step-by-step processes of installing and configuring the ODBC driver for MySQL. In particular, it will cover the following issues:

Installing the ODBC driver on Windows 10.
Configuring the ODBC data source with ODBC driver for MySQL.
Creating a basic list report with PowerBI that uses the ODBC driver for the data population from the MySQL database.

Understanding MySQL Create View, Replace View and Drop View Statements

February 1, 2021February 3, 2021 Nisarg Upadhyay Leave a comment

Total: 0 Average: 0

An SQL view is a virtual table or a result-set generated by the SELECT query. Unlike physical tables, views do not store data in a database. When we run the SELECT query to populate the data, it executes a query that creates the view (View definition).

Top 5 MySQL CREATE TABLE Syntax for T-SQL Developers

January 28, 2021January 28, 2021 Edwin Sanchez Leave a comment

Total: 0 Average: 0

Are you a T-SQL developer learning the basics of MySQL? Then, one of the things you might want to learn is MySQL CREATE TABLE. Besides, the fastest way to learn a new SQL database platform is by comparing its common functionality and syntax.

That’s what we are going to do today. But the full syntax is a lot. So, we will only cover 5 basic points to get you up and running with MySQL CREATE TABLE.

Understanding MySQL TRUNCATE TABLE by Practical Examples

January 5, 2021January 19, 2021 Nisarg Upadhyay Leave a comment

Total: 1 Average: 5

MySQL TRUNCATE TABLE statement is a DDL statement used for removing all records from the MySQL table. When we run this command, it drops the existing table first and then creates a new table using the table definition. The query execution sequence of the TRUNCATE TABLE command is DROP TABLE and CREATE TABLE.

How to Parse Strings Like a Pro Using SQL SUBSTRING() Function?

January 4, 2021January 19, 2021 Edwin Sanchez Leave a comment

Total: 1 Average: 5

Do you enjoy parsing strings? If so, one of the indispensable string functions to use is SQL SUBSTRING. It is one of those skills a developer should have for any language.

So, how do you do it?

10 Best MySQL GUI Tools

September 10, 2019September 30, 2019 {coding}Sight Leave a comment

Total: 75 Average: 4.5

MySQL is among most widely-used and popular database technologies, so quite a lot of tools have been created in order to make the processes of designing, creating, and administering databases easier and more convenient. However, with all of the possible options, it can be difficult to choose one tool that will fit your requirements best. That is why I prepared a list of 10 MySQL GUI tools that, in my opinion, are the best solutions both for developers and DBAs alike.

Let’s take a closer look at them. Read More