This is a collection of articles regarding the MySQL utility mysqldump that were previously published on this blog. This is for quick reference.
Category: MySQL
Get a random number between two given numbers in MySQL
The following example shows how to generate a random number between two provided numbers. This may be useful in situations when the random number must
Insert 10000 records using WHILE loop in MySQL
Based on the maximum and minimum parameters provided, the example will insert 10000 records into a table. The goal of this example is to show
SQL DBA – Check SQL Services status across multiple servers
Working with so many database servers necessitates checking to see if the Windows services are operating in each instance. This is especially important if you
LOAD XML File into a table – MySQL
This article shows how to import XML data into a MySQL table. Once the data is imported into the table, you’ll see the data in
SQL_CALC_FOUND_ROWS and FOUND_ROWS in MySQL
A LIMIT clause can be used in a SELECT query to limit the number of rows the server returns to the client. In some circumstances,
Big Data & SQL 