MySQL Tutorials, Tips and Tricks on various how to do things
Introduction – MySQL to Redshift Load Before we talk about data load from MySQL to Redshift using SSIS, first lets talk what is Amazon Redshift (or AWS Redshift). Amazon Redshift is a Cloud based Data warehouse service. This type of system also referred as MPP (Massively Parallel Processing). Amazon Redshift uses highly modified version of […]
Introduction In this article we will learn how to use ZappyShell Command Line Tools for MySQL CSV Export from Table or Query result ZappyShell for DB can export your MySQL data to CSV, PDF, Excel in one line command. This is just single exe less than 5 MB.. CSV export allows you to export data […]
Introduction In this article we will learn how to use ZappyShell Command Line Tools for MySQL Excel Export from Table or Query result The problem There is no native way of Exporting MySQL Data to Excel. You can use some coding techniques or libraries but when things become complex you will run out of options […]
Introduction In this article we will learn how to use ZappyShell Command Line Tools for MySQL JSON Export from Table or Query result JSON File format is becoming very popular due to its simplicity and smaller size. Most of NoSQL Databases are now using JSON for their document mechanism. The problem There is no native […]