Best way to insert data into MySQL?

[Jander]

So I am building a website for one of my class projects and am going to be inserting a large amount of data into tables and was wondering about the best method to go about doing this. Insert from Excel, wordpad etc...

Thanks

~J

[jerdo]

Depends on the type of database you are using. If you are using MySQL, PostGRE, etc you would probably want a php or perl script. If you are using Access of some other Microsoft thing you will probably just want to use what's built into that.

[Jander]

Using MySQL, I want to be able to type the data into a excel document and insert into MySQL instead of doing it line by line in the command line.

[jerdo]

You could use phpMyAdmin and import it from the excel document maybe, or import the document from the command line. Or if you are using phpMyAdmin you could just type the data directly from there they same as you would into the Excel spreadsheet (once you setup the db). You could also write a php script that takes the info from a webform and puts it in the db directly, yet again cutting out the excel thing.