Tag: mysql

10 Best MySQL GUI Tools

{coding}Sight Leave a comment
Total: 74 Average: 4.6

MySQL is among most widely-used and popular database technologies, so quite a lot of tools have been created in order to make the processes of designing, creating, and administering databases easier and more convenient. However, with all of the possible options, it can be difficult to choose one tool that will fit your requirements best. That is why I prepared a list of 10 MySQL GUI tools that, in my opinion, are the best solutions both for developers and DBAs alike.

Let’s take a closer look at them. Read More

Conditional Split Transformation: Export Data from SQL Server into Oracle and MySQL Databases

Nisarg Upadhyay Leave a comment
Total: 10 Average: 3.8

In this article, I have explained how we can divide and export data of SQL Server database table into Oracle and MySQL databases. That process is based on the condition defined in SSIS as “conditional split transformation”. Conditional split transformation is like case statement of any programming language. Using conditional, we can redirect the output of a component in multiple destinations that is based on a condition defined in the conditional split component. Read More

Pivot Tables in MySQL

Alexey Mikotkin 1 Comment
Total: 101 Average: 4.8
  1. Briefly about Pivot tables
  2. Pivoting data by means of tools (dbForge Studio for MySQL)
  3. Pivoting data by means of SQL
  4. Automating data pivoting, creating query dynamically

Briefly about Pivot tables

This article deals with the transformation of table data from rows to columns. Such transformation is called pivoting tables. Often, the result of the pivot is a summary table in which statistical data are presented in the form suitable or required for a report. Read More