I don't mean to be cynical but this is elementary...and no mention of one of the most common tools used by PHP/MySQL Devs and installed on practically every LAMP Hosting environment: http://www.phpmyadmin.net/
So far two authors accepted to submit their articles. Maybe the articles are not as great as you would like, but since it is contributed content the site cannot demand much unless there is a greater offer of articles.
Anyway, if you would like to contribute better quality articles about PHPMyAdmin or something else you think it is interesting, feel free to do so. I will talk more about this in an upcoming article, but you can submit your article proposals already in this page:
Rinie Kervel - 2009-02-26 07:32:35 - In reply to message 4 from jorge
CSV is not that simple... ; or , headers or not...
Nice function in the source is:
//gets count of each possible CSV separator
//returns most appropriative separator (by max count in the string)
public static function try_separators($line, $default=','
I would have liked that you can save the mapping,
so that you can select the mapping (or create a new one) and process the file...
John Cherry - 2009-07-08 00:05:29 - In reply to message 1 from Nicholas Calugar
Yes, the article was a little light on detail, but my recent reading of forums (not this one, I'm a newcomer here) suggests that there is no lower limit to the level of detail you should supply.
The other day, I was preparing CSV files for insertion into a MySQL database. They contain numerical information and I opened one in Excel just to have a look at the data (while making a mental note not to save it because Excel would change date formats and numerical precision.
Excel said 'whoa, this is a SYLK file, are you sure you want to open it?'