Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007
    Posts
    21

    Unanswered: Export to CSV based on query -- Help

    Hello,
    I'm not sure how to do this, or if it's even possible.

    I would like to export two tables in to multiple csv files. I have two tables called "users" and "user_files". I would like to loop through "users" and for each user create a separate "csv" export of user_files based on user id.

    Is this possible?

    Thanks,
    tom

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by tjones1105 View Post
    Is this possible?
    not with just mysql by itself

    however, with an application language like php, yes, it's possible
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Aug 2003
    Posts
    19
    Thanks, I'll look at scripting it.

Posting Permissions

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