Will SequelPro enable me to take a three dimensional MYSQL database to a single csv or xls file?

[varicos...@gmail.com]

I have an electronic medical record that I need to share medical data for research purposes.  Of course this is kept private, yet it is the capability of SequelPro that has me asking the question.

Please share your advice and expertise.  The MaxOS leaves few consultants able to assist, so I am attempting to try this myself if the program will work.

[Adrian Beale]

Hi Marlin,

You can do this using MySQL with some caveats. Sequel Pro itself doesn't have any features (I'm aware of) that extend the core MySQL functionality. The main issue is going to be that this process is one way, you can "dump" data into a CSV easily, especially from a view that includes all the required lookups and relationships, but you can't then edit the CSV and upload it easily. If you are still working on this, let me know and I'll see if I can help.