What's the best way to populate a table?

[stahler]

Hi folks, given that it is very tedious to enter data into a table using command lines parameters (especially if you have hundreds of entries to make), is there not a better way to enter data, for example using an import command (I tried using the DATA INFILE command and it resulted in some data being left out).

Help appreciated,

Doug

[KeithMcL]

What kind of data are you populating the table with? It is basic text? You could just write the data to a textfile and then use phpMyAdmin to import the file info.

[harbornetworks]

I agree with WebDevInfo on that one. You can also create the insert statements in a text editor and then run the .sql file in the command line MySQL. Be sure to have your code properly formatted with the ';' in the propper places.

[PhilG]

Sometimes if I have an excel sheet that I want to easily insert into a table I use HomeSite's regular expressions.

I find it very handy to do it the HomeSite way if you are on a 56k connection since most of the time the connection to PhpMyAdmin times out...