Saving a table to CSV file.

[expired user #8644]'s profile image [expired user #8644] posted 9 years ago in Import/Export Permalink
I am very new to SQL in general. I have a basic table with 5 columns and 60,000 rows of data. anyone any idea how to save this to a CSV file? I am scared to try anything as I can lose this table as it is for my dissertation for University...
[expired user #8644]'s profile image [expired user #8644] posted 9 years ago Permalink
I got from a previous post: http://www.heidisql.com/forum.php?t=6533
Sorry!
[expired user #8781]'s profile image [expired user #8781] posted 9 years ago Permalink
Hey croc123,
Did you try this?
Perform a Select to get the data into the results table.
Right click in the results table and use "Export Grid Rows".
Then you can export to almost any format you want including CSV!
Cheers

[expired user #8811]'s profile image [expired user #8811] posted 9 years ago Permalink
anyone any idea how to save this to a CSV file? I am scared to try anything as????



________________
han ya na kuch tu kaho

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