Insert Multiple Rows phpMyAdmin

I\'ve just discovered a relatively easy way to add multiple records to a mysql database. If you\'ve got phpMyAdmin installed, use it, go to the "SQL" tab of the table in which you wish to bulk add records. Hidden at the bottom of the page is a like to "Insert data from a textfile into table."

You\'ll need to create a text file in notepad or something... it\'s relatively straight forward if you\'re used to this sort of task.

Related Scribbles:
  • MySQL Notes


  • ID: 388
    Author:
    leonard
    Date Updated:
    2004-01-06 14:48:19
    Date Created:
    2004-01-06 14:48:00

    Edit

    Comments?
     >> Leonard Chan's Homepage  >> Scribble Web  >> Insert Multiple Rows phpMyAdmin
    leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.