How to choose database software?

D

Dim Boy2016-02-04 03:03:43

MySQL

Dim Boy, 2016-02-04 03:03:43

I can not find a simple software for robots with a database. The essence of what you need:
There are a bunch of columns in the database, you need to select only unique records from one column and export to csv, xlsx.
Also, by analogy, from the unique records selected, they can also be sorted from other columns and exported.
But it is necessary that in a few clicks, and it was easy for a person to explain.
Navicat, heidisql, dbForge Studio for MySQL are not suitable....
You can also offer software for MS SQL!
Each table of data in excel is over 1 GB.

Reply

Answer the question

In order to leave comments, you need to log in

4 answer(s)

D

Dim Boy, 2016-02-15
@twix007

Solution - Power Pivot

V

Vasiliy Vakulenko, 2016-02-06
@kabasik007

Libre office

M

My joy, 2016-02-04
@t-alexashka

If such products as dbForge and heidi do not suit you, try to export to csv with any tool and work in Excel.

Z

Zhainar, 2016-02-04
@zhainar

create a view with the data you need and export via HeidiSQL.