How to Change Default MySQL Port in Windows 10
A network port is a communication endpoint used by applications, incoming connections, and external...
Automation of Database Maintenance in SQL Server 2019 Express Edition
This article explains how to automate the database maintenance tasks in SQL Server Express Edition. In terms of automation of database...
Drop Temp Table in SQL Server and PostgreSQL
This article explains different ways to drop the temp table in SQL Server and PostgreSQL. As the name suggests, temporary tables are used...
Reset the Root Password of MySQL on Windows
When we install MySQL on Windows, we usually specify the password of the root user. This helps keep...
Different Ways to Populate the Users of MySQL
This article explains different methods to populate the details of the Users in MySQL. We can view the list of users by using any of the...
Install and Configure XAMPP Software on Windows Server 2019
XAMPP is a cross-platform web server used to develop and test programs and web applications, created by the Apache friends organization....
Different Ways to View Tables in MySQL Server
There are two primary methods to view the tables in MySQL: The MYSQL SHOW TABLES command. Querying...
SQL Server RAISERROR Statement with Simple Examples
The SQL RAISERROR statement is used to send a custom message to the client application. It also can be used to debug the application and...
SQL DROP Index, DROP Table, and DROP Database Statements Explained with Examples
The SQL DROP statement is a command that deletes existing database components or the entire databases with all their data permanently....
How to Delete Entire MySQL Database
In some cases, we need to drop the entire database from the MySQL community server. This is simple...