New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL Export - add row limit option #341

Open
penCsharpener opened this Issue Sep 3, 2018 · 3 comments

Comments

Projects
None yet
2 participants
@penCsharpener
Copy link

penCsharpener commented Sep 3, 2018

Use case

This is related to issue 340 as well but not worth linking with #.
When exporting data from a production to a local/sandbox instance of MySQL a developer doesn't always need all the rows of a large table. That just adds unnecessary traffic and time.

Current behavior

Export entire table or nothing or just table structure.

Expected behavior

An option that allows the developer to just export / copy the last 100 or 1000 rows.

Possible solution

The menu would need a column dropdown for the table in question by which the sorting happens, a sort order (ASC or DESC) and the number of rows. Heidi could prefilter to only include id columns or date columns. I don't see any use for text fields.

Environment

  • HeidiSQL version:
    9.5.0.5293
  • Database system and version:
    MySQL 5.7.23 and MariaDB 10.3.6
  • Operating system:
    Win 10 1803

@ansgarbecker ansgarbecker changed the title [Feature Request]: SQL Export - add row limit option SQL Export - add row limit option Sep 7, 2018

@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

ansgarbecker commented Oct 9, 2018

A sorting order (and limit also) would be on a per-table basis. So that could live in the left tree in a new column with a dropdown when editing.
grafik

@penCsharpener

This comment has been minimized.

Copy link
Author

penCsharpener commented Oct 14, 2018

yes, good idea. But in your mockup you have a "name". I don't quiet see a use for alphabetical sorting.

@ansgarbecker

This comment has been minimized.

Copy link
Collaborator

ansgarbecker commented Oct 14, 2018

I can already see others asking "where are the other column names?" :)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment