Quick SQL help please!!!

Discussion in 'OT Technology' started by AbortionSurvivor, Jul 7, 2005.

  1. AbortionSurvivor

    AbortionSurvivor Active Member

    Joined:
    Jun 5, 2002
    Messages:
    3,016
    Likes Received:
    0
    Location:
    Nor. Cal
    I need to populate a simple table with lots of data. It could be only 1 column, but I need at least 10K or 100K rows.

    The entries for the rows should be different so I was just thinking INTS.

    this table would be used for testing.
    What's a simple script I could use to do this?

    Thanks!!!
     
  2. RyanL

    RyanL OT Supporter

    Joined:
    Nov 30, 2004
    Messages:
    4,584
    Likes Received:
    0
    Location:
    St. Paul, MN
    can it be a php script?
     
  3. AbortionSurvivor

    AbortionSurvivor Active Member

    Joined:
    Jun 5, 2002
    Messages:
    3,016
    Likes Received:
    0
    Location:
    Nor. Cal
    sorry. I don't know PHP.
    I could like it to be a SQL script. Something I can run in CLI
     
  4. AbortionSurvivor

    AbortionSurvivor Active Member

    Joined:
    Jun 5, 2002
    Messages:
    3,016
    Likes Received:
    0
    Location:
    Nor. Cal
    i was thinking about looping an Insert statement. but i'm not sure how the loop would go.
     
  5. RyanL

    RyanL OT Supporter

    Joined:
    Nov 30, 2004
    Messages:
    4,584
    Likes Received:
    0
    Location:
    St. Paul, MN
    Sorry I can't much help then... :dunno:
     
  6. P07r0457

    P07r0457 New Member

    Joined:
    Sep 20, 2004
    Messages:
    28,491
    Likes Received:
    0
    Location:
    Southern Oregon
    hmm... sounds like a 10-line php script... Just a quick for-loop.
     
  7. AbortionSurvivor

    AbortionSurvivor Active Member

    Joined:
    Jun 5, 2002
    Messages:
    3,016
    Likes Received:
    0
    Location:
    Nor. Cal
    anyone know about dbgen?
    that seems to be what i need, but i don't have the MS resource CD. *i thnk*
     
  8. Frequency

    Frequency New Member

    Joined:
    Dec 30, 2004
    Messages:
    7,504
    Likes Received:
    0
    Location:
    PA

Share This Page