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.