The SELECT… INTO OUTFILE statement is meant to allow the server host to dump a table to a text file. SELECT… INTO OUTFILE is the
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.
Backup a single table – MySQL
It is occasionally necessary to take a table backup before applying data corrections or structural modifications to a table. In the event of a problem,
Dynamic SQL – Export Data
As specified in the previous post, the method we use to write SQL queries so that they are dynamically built alongside application actions is known
Error Handling – RAISERROR
In my earlier essay, I discussed SQL Server’s error handling in great detail. This is a follow-up post; it discusses RAISERROR, which produces an error
Error Handling – Introduction
In SQL Server, error handling (also known as exception handling) offers us control over the Transact-SQL code and aids in diagnosing the precise point where
LOAD DATA INFILE – MySQL – Errors
Rows from a text file are quickly read into a table using the LOAD DATA statement. Depending on whether the LOCAL modifier is specified, the
Big Data and SQL 