SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Enthusiast
    Join Date
    Jan 2009
    Posts
    40
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question How to export multiple tables as one csv file

    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?

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,220
    Mentioned
    58 Post(s)
    Tagged
    3 Thread(s)
    most front end apps (e.g. phpmyadmin) can export the result of a query
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    Non-Member thewebhostingdir's Avatar
    Join Date
    Oct 2005
    Posts
    703
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Check below tutorial. It will guide you through the exact steps:

    http://www.ineedtutorials.com/code/p...comment-page-1


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •