ItsWesYo Posted August 20, 2006 Share Posted August 20, 2006 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 myphpadminb) take my time typing ('item1'),('item2'),etc (takes a long time)Any easier way? Quote Link to comment https://forums.phpfreaks.com/topic/18137-easier-way/ Share on other sites More sharing options...
AndyB Posted August 20, 2006 Share Posted August 20, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/18137-easier-way/#findComment-77780 Share on other sites More sharing options...
fenway Posted August 21, 2006 Share Posted August 21, 2006 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. Quote Link to comment https://forums.phpfreaks.com/topic/18137-easier-way/#findComment-78175 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.