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,
Author: SHAFI SHAIK
Hi, this is Shafi Shaik, Microsoft Solutions Specialist in Data platform as well as in Data Management & Analytics. I am a certified associate in Oracle SQL*Plus and extensively trained in MongoDB Administration. My current role is Database administration with hands-on expertise in almost all relational databases namely Microsoft SQL Server, MySQL, Oracle SQL*Plus, PostGreSQL & Teradata. I'm also specialized in database development, warehousing, traditional data analysis and Big Data analysis.
CREATE PROCEDURE IF NOT EXISTS in MySQL
During various migrations/deployments, it is required to check to see if the stored routine (stored procedure or user-defined function) already exists before creating it. Because
MySQL Database Cloning
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and
mysqldump – ignore a single or multiple tables
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and
mysqldump – backup of multiple databases
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and
mysqldump – Include views, routines and triggers
The mysqldump client utility performs logical backups, producing a set of SQL statements that can be executed to reproduce the original database object definitions and
Big Data & SQL 