How to export to csv with data a temporary table from a view
I need to export to csv the data and structure from a view. Can anyone help me figure this out. I should add that i know NOTHING about HeidiSQL, or SQL for that matter. I am a FileMaker developer and have been asked to duplicate a HeidiSQL database in FileMaker.
Yes. Copy the command from the bottom (SELECT * FROM `xxx`.`yyy` LIMIT 1000, 99000;) without the LIMIT clause, open a query tab, paste, F9. Then export. Hope your heidi does not crash. Otherwise you have got try more tricks.
Advice: You are trying to export a view. Would it not be better to take the original table(s) and rebuild the view in your own database?
Advice: You are trying to export a view. Would it not be better to take the original table(s) and rebuild the view in your own database?
wrwaugh, I read that FileMaker can connect to SQL databases. Figure out how Heidi connects to your database and try the same with FileMaker. Thus you might be able to extract your data directly. Or ask someone to do the extraction word for you, it should not be a big deal. Good luck, Wolfgang
Please login to leave a reply, or register at first.