Mysql command
Results 1 to 6 of 6

Thread: Mysql command

  1. September 11th, 2006, 09:23 AM #1
    cgonzo
    cgonzo is offline
    Registered User cgonzo's Avatar
    Join Date
    Dec 2002
    Posts
    114

    Mysql command

    Here is the situation: I have a csv file. The file has:
    row 1 jsmith, math
    row 2 jsmith, english
    row 3 jsmith, history
    row 4 jsmith, science
    row 5 jdoe, math
    row 6 jdoe, science
    row 7 jdoe, english
    row 8 jdoe, spanish
    etc.
    What I want is to end up with is this:
    row 1 jsmith, math, english, history, science
    row 2 jdoe, math, science, english, spanish

    Any ideas? Access, Excel or Mysql? Help please.
    Reply With Quote Reply With Quote
  2. September 12th, 2006, 05:11 AM #2
    NooNoo
    NooNoo is offline
    Driver Terrier NooNoo's Avatar
    Join Date
    Dec 2000
    Location
    UK
    Posts
    31,824
    group by.... but I assume you want another csv output?
    So I suggest you create a new table, then update each row in the new table with the data from the old using a loop...

    In excel I think you could achieve that with a vbscript...

    Which approach would you prefer?
    Last edited by NooNoo; September 12th, 2006 at 05:20 AM.
    Reply With Quote Reply With Quote
  3. September 14th, 2006, 06:04 AM #3
    cgonzo
    cgonzo is offline
    Registered User cgonzo's Avatar
    Join Date
    Dec 2002
    Posts
    114
    Thanks, Noo Noo for your attention to my problem. I think an Excel solution would be great.
    Reply With Quote Reply With Quote
  4. September 14th, 2006, 06:06 AM #4
    NooNoo
    NooNoo is offline
    Driver Terrier NooNoo's Avatar
    Join Date
    Dec 2000
    Location
    UK
    Posts
    31,824
    And you know how to write vbscript?
    Reply With Quote Reply With Quote
  5. September 14th, 2006, 06:13 AM #5
    cgonzo
    cgonzo is offline
    Registered User cgonzo's Avatar
    Join Date
    Dec 2002
    Posts
    114
    I have a guru I can consult with.
    Reply With Quote Reply With Quote
  6. September 14th, 2006, 07:02 AM #6
    NooNoo
    NooNoo is offline
    Driver Terrier NooNoo's Avatar
    Join Date
    Dec 2000
    Location
    UK
    Posts
    31,824
    Cool so case closed!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Backing Up MySQL in Windows?
    By houseisland in forum Other Software Applications
    Replies: 5
    Last Post: September 13th, 2006, 07:16 AM
  2. Command line command question
    By Percy in forum Windows NT/2000
    Replies: 10
    Last Post: January 15th, 2002, 02:40 PM
  3. more .bat file questions...
    By tablesalt in forum DOS
    Replies: 30
    Last Post: May 20th, 2001, 07:51 PM
  4. NTBackup, batch files, AT command and permissions
    By Underseer in forum Windows NT/2000
    Replies: 9
    Last Post: April 26th, 2001, 09:46 AM
  5. Disabling the Find F3 command
    By ClintDaddy in forum Windows 95/98/98SE/ME
    Replies: 1
    Last Post: October 28th, 1999, 03:35 PM

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
  •  

Forum Rules