Quote:
|
Originally Posted by Maljonic
Hi, I've been looking for simple software to edit .sql files for ages and just happened across this forum so I thought I'd ask. Is there a program that lets me open sql files offline, edit them in columns like using excel with exel files, and saves them as sql file without any fuss.
|
I don't understand what you are aiming at. A "SQL File" is (in my understanding) a file that contains SQL statements (such as SELECT, UPDATE, DELETE). It cannot be edited "in columns".
Do you by any chance mean to edit the
data data of a table e.g. in a tab-separated text files? (aka "CSV")?
This should be possible using Excel or OpenOffice without problems, but that is not a MySQL problem.
I don't know HeidiSQL but probably you can simply run the SELECT there, and then edit the data directly in the result.