This article is meant for people who are just learning SQL. DML commands typically touch the database through apps; users don’t sit down and manually
mysqldump – Dump only specific rows
It is possible to dump a specific table and specific rows from a table using mysqldump. This article explains how to do that. The mysqldump
MySQL – Single Transaction or Skip Lock Tables
When using mysqldump to backup databases, many people are unsure whether to use the –skip-lock-tables or –single-transaction options to prevent locking the tables. This article
MySQL Status through mysqldump
You can easily run the following line at command prompt to retrieve the MySQL server uptime statistics along with the number of connected threads, the
Corelated Sub-Queries
A correlated subquery is one that makes use of values from the outer query. Because of this dependency, a correlated subquery cannot be executed as
String and Arithmetic Expressions in SQL Server
The intention of this post is to explain the regularly used string and arithmetic expressions. CHARINDEX: This function searches for a substring in a string,
Big Data & SQL 