How would a client of mine export a mysql database in say a .csv format, when the data is abstracted across multiple tables? (Since having a crack at normalising my database, it has become less human-readable!)
Is there way in phpmyadmin to perform an SQL command that say joins all tables together and then export the results of the SQL? That could potentially be a large amount of data though...
Any ideas so the client can have a readable spreadsheet file ie. .csv?
most front end apps (e.g. phpmyadmin) can export the result of a query