Jump to content

Archived

This topic is now archived and is closed to further replies.

ItsWesYo

Easier Way?

Recommended Posts

Is there an easier way to add about 406 items (names of items) into a database?

I will not:
a) add 2 at a time using the insert thing in myphpadmin
b) take my time typing ('item1'),('item2'),etc (takes a long time)

Any easier way?

Share this post


Link to post
Share on other sites
Put the data relevant to 406 things in an Excel spreadsheet with the same column order as your database table and then export the data as a CSV file which you can then import directly into your database using phpmyadmin.

Share this post


Link to post
Share on other sites
Also, depending on the source file itself, it should be trivial to generate a whole bunch of INSERT statements with a half-decent text editor and some macros / regexs.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.