Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2004
    Posts
    2

    Unanswered: filling database

    Hi

    I am filling my database with a couple of thousend
    8 digits numbers. These numbers i have in a list in a text-file.
    Also I have a dump-sql file that i fill with these numbers by copying and pasting the numbers in between the brackets after the word VALUES in the following sentence:

    INSERT INTO NUMBERS (number) VALUES ();

    resulting in;

    INSERT INTO NUMBERS (number) VALUES (12345678);

    That i repeat with all the numbers

    This takes me forever.....!

    Is their anybody who knows a quicker way...?
    I would appriciate any suggestions deerly!

    Greetings

    Meeusen

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Check the MySQL manual online.

    -PatP

  3. #3
    Join Date
    Jun 2004
    Posts
    2
    thank you !!!

Posting Permissions

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