Export of SQL-Data in CSV

jk3 posted 2 years ago in General

Hello everybody,

I would like to know, how it is possible to export my sql data from HeidiSQL into CSV files. I know that it is possible to export the SQL Database (Tools), but how do I manage it for a CSV output?

I think it is really easy but I am just started to work with heidisql and that's why I hope, that somebody can help me with this concern.

Thanks a lot in advance.

Mifczu posted 2 years ago

RPM on results and click export option. Is that is what you mean?

ansgar posted 2 years ago

CSV files are generated in HeidiSQL with a right-click on any data result, plus clicking "Export grid data". Many other output formats can be selected there, amongst CSV.

jk3 posted 2 years ago

Thanks a lot for your answers! I already found a way to solve my problem.

ilyar posted 3 weeks ago

I've exported the file but all long IDs converted and ruined: This one: 100001100000026336 converted to: 1.00001E+17 How do I keep the original one?

ansgar posted 3 weeks ago

1.00001E+17 is just a scientific format of the number 100001000000000000.

But the very right digits are cut off, so the numbers are really ruined.

But I'm sure this is not done by HeidiSQL itself, or?

Please login to leave a reply, or register at first.