MySQL INSERT IGNORE Clause
Guide on how to use the INSERT IGNORE clause to allow MySQL to disregard any row that contains an invalid data instead of terminating the entire insert block.
SQL Server System Functions
Practical tutorial on how to perform the SQL Server system functions to optimize the database operations and extract useful information from our data.
SQL Server Materialized Views
Practical tutorial on how to create the materialized views and the concept of materialized views in SQL Server and discuss their benefits over regular views.
SQL Server User-Defined Functions
Guide on how to create, modify, and use the user-defined functions in SQL Server to improve the code organization and enhance the overall database performance.
STRING_AGG Function in SQL Server
Guide on how to sort the concatenated results, group the expressions based on specific columns, and remove the duplicate values using the STRING_AGG function.
How to Extract Data from JSON Type in MySQL
Practical tutorial on how to extract the data from JSON type and how to work with JSON data types in a MySQL table to extract the different data from columns.
How to Show the Running MySQL Processes
Tutorial on how to show the running MySQL processes, how to kill a running process, and how the MySQL SHOW PROCESSLIST works using syntax and example command.
How to Use the MySQL HAVING Clause Where the Sum Is Greater Than the Threshold
Practical tutorial on how to work with the MySQL HAVING clause where the sum is greater than the threshold to execute a filter query and apply the groupings.
Import JSON into MySQL
Comprehensive tutorial on how to import JSON from a file and JSON string into the MySQL XAMPP server with the PHP script using the “job_details” MySQL table.
How to Remove Records from Table With MySQL Workbench?
To remove records from the table with MySQL Workbench, the “DELETE FROM WHERE ;” command can be used.
How Would You Get the Current Date in MySQL?
To get the current date in MySQL, run “SELECT CURDATE();”, “SELECT UTC_DATE();”, “SELECT DATE(CURRENT_TIMESTAMP());” or “SELECT DATE(NOW());” command.
How to use Now() Function in MySQL | Explained with Examples
MySQL “NOW()” function is used to extract the current time and date of the system running MySQL server in string format (YYYY-MM-DD HH-MM-SS).
How to Use Different Flags While Exporting MySQL Database?
To export MySQL databases, mysqldump utility can be used along with various flags for exporting single, multiple databases with their data and even structures.
How Do I Create a New Database in MySQL
To create a new database in MySQL using the Windows terminal, the “CREATE DATABASE <new-databasename>” command can be used.
How to List the Users in a MySQL Database
To list the users in a MySQL database, the “SHOW user()” statement, “SHOW current_user()” statement, or “SELECT” statement can be used.
How to Check MySQL Version Using Workbench?
To check the MySQL version by utilizing the Workbench, open Workbench > Select Connection> Server Tab> Server Status option> Check version.
How to Check MySQL Version Using Windows Terminal?
To check the MySQL version using the Windows terminal, the “SELECT VERSION”, “SHOW VARIABLES LIKE” statement, or the “STATUS” command can be used.
How to Change MySQL Root Password in Linux or Windows
To change the MySQL root password in Windows and Linux, use the command “ALTER USER ‘root’@’localhost’ IDENTIFIED BY ”;”.
How to Automatically Backup MySQL Database Using Python
To automatically backup MySQL database. Create a Python script with database details, backup interval time, and mysqldump command for creating backup files.
How to Automatically Backup MySQL Database Using PHP
Create a PHP file with MySQL database credentials and backup file name. Use mysqldump command to create a backup file and Task Scheduler to automate the process.