Uncategorized

Export SQL Data Into A CSV

You can easily export SQL data into a csv. Useful for a lot, such as reverse engineering. Here, we’ll look at dumping the application_name and application_path columns from the jamfsoftware.applications database into a file called apps.csv:

select application_name,application_path from jamfsoftware.applications into outfile ‘/tmp/apps.csv’ fields terminated by ‘,’ lines terminated by ‘\n’;