mysql Archives - {coding}Sight https://codingsight.com/tag/mysql/ Blog for SQL Server DBAs and Developers Wed, 11 Oct 2023 06:22:57 +0000 en-US hourly 1 https://wordpress.org/?v=6.5.2 https://codingsight.com/wp-content/uploads/2021/10/cropped-Soсial_-Fb_180х180-1-32x32.png mysql Archives - {coding}Sight https://codingsight.com/tag/mysql/ 32 32 dbForge Edge: Your Best Universal Tool for Multidatabase Challenges https://codingsight.com/introducing-dbforge-edge/ Tue, 06 Jun 2023 11:34:26 +0000 https://codingsight.com/?p=24719 Handling several database management systems simultaneously is inevitable in working on multiple projects. At the same time, each system requires a proper set of relevant tools to perform database tasks. These tools should be powerful and flexible enough to adapt to the project’s evolving needs. One moment, your goal is to design a new database …

The post dbForge Edge: Your Best Universal Tool for Multidatabase Challenges appeared first on {coding}Sight.

]]> How to Change Default MySQL Port in Windows 10 https://codingsight.com/how-to-change-default-mysql-port-in-windows-10/ Sun, 18 Sep 2022 17:20:00 +0000 http://codingsight.com/?p=16885 A network port is a communication endpoint used by applications, incoming connections, and external devices to the computer/server or specific application. In this article, we’ll discuss MySQL ports and learn how we can change the default port on Windows 10. Table of contents Every RDBMS has its default port to accept incoming connections. The below …

The post How to Change Default MySQL Port in Windows 10 appeared first on {coding}Sight.

]]> How to Comment MySQL Code: Best Practices https://codingsight.com/comment-function-mysql-make-the-best-use-of-it/ Thu, 05 Aug 2021 11:00:50 +0000 http://codingsight.com/?p=15958 Comments are used to add information to the code. It is mostly ignored by the compiler, but human specialists can read those comments when they view your code. Comments are essential for developers because they have limited time, and commenting allows them to get valuable information at once or note some crucial details in regards …

The post How to Comment MySQL Code: Best Practices appeared first on {coding}Sight.

]]> How to SHOW or LIST Tables in MySQL https://codingsight.com/different-ways-to-view-tables-in-mysql-server/ Mon, 26 Jul 2021 08:54:23 +0000 http://codingsight.com/?p=15772 There are two primary methods to view the tables in MySQL: In this article, we are going to explore them both. MySQL SHOW TABLES Command The show tables command displays the list of all tables created in a database. The syntax is as follows: In the syntax, Let us see the examples. Example 1: Show …

The post How to SHOW or LIST Tables in MySQL appeared first on {coding}Sight.

]]> MySQL UPDATE: Top 5 Tips for T-SQL Developers https://codingsight.com/mysql-update-top-5-tips-for-t-sql-developers/ Fri, 07 May 2021 08:48:57 +0000 http://codingsight.com/?p=13568 Are you adding MySQL to your list of database skillsets? Then MySQL UPDATE statement is one of the commands you need to learn. We are continuing our journey to MySQL from the SQL Server point of view. It started with CREATE TABLE, followed by INSERT, and the most recent piece was about DELETE. Today, UPDATE is our focal …

The post MySQL UPDATE: Top 5 Tips for T-SQL Developers appeared first on {coding}Sight.

]]> Successful MySQL/MariaDB Backup and Recovery Strategies https://codingsight.com/successful-mysql-mariadb-backup-and-recovery-strategies/ Tue, 06 Apr 2021 14:32:10 +0000 http://codingsight.com/?p=12592 A vital part of preventing any kind of data loss in any situation is having appropriate backup and recovery policies. It is also essential to ensure data recovery at any point in time of the application workflow life cycle. Both MySQL and MariaDB offer solutions for these cases. This article will explore the existing options …

The post Successful MySQL/MariaDB Backup and Recovery Strategies appeared first on {coding}Sight.

]]> TOP 5 MySQL Delete Syntax with Tips for T-SQL Developers https://codingsight.com/top-5-mysql-delete-syntax-for-t-sql-developers/ Tue, 23 Mar 2021 10:12:32 +0000 http://codingsight.com/?p=12492 Our journey to MySQL started with CREATE TABLE followed by INSERT. Today, we are proceeding to the MySQL DELETE statement. It is almost as common as the MySQL UPDATE statement. Since you are familiar with T-SQL DELETE, the goal is to make you more productive using the MySQL syntax. There are minor differences in these DELETE statements, but …

The post TOP 5 MySQL Delete Syntax with Tips for T-SQL Developers appeared first on {coding}Sight.

]]> How to install MySQL Server on Ubuntu 18.04 in 2 Different Ways https://codingsight.com/quick-guide-on-installing-mysql-on-ubuntu/ Thu, 18 Feb 2021 08:48:05 +0000 http://codingsight.com/?p=12108 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. It’s important to note that this guide is suitable for installation on all versions of Ubuntu. I’d recommend you …

The post How to install MySQL Server on Ubuntu 18.04 in 2 Different Ways appeared first on {coding}Sight.

]]> Backup and Restore MySQL Database Using mysqldump https://codingsight.com/backup-and-restore-mysql-database-using-mysqldump/ Wed, 17 Feb 2021 14:38:43 +0000 http://codingsight.com/?p=12073 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. Note: On CodingSight you can also read about other MariaDB and MySQL backup strategies. For demonstration purposes, I created a demo database named …

The post Backup and Restore MySQL Database Using mysqldump appeared first on {coding}Sight.

]]> How to Create and Deploy Azure Database for MySQL Server using Azure Portal and Workbench https://codingsight.com/understanding-azure-database-deployment-on-mysql/ Wed, 17 Feb 2021 14:26:37 +0000 http://codingsight.com/?p=12050 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 MySQL pricing model and various Azure subscriptions, refer to Subscriptions, licenses, accounts, …

The post How to Create and Deploy Azure Database for MySQL Server using Azure Portal and Workbench appeared first on {coding}Sight.

]]>