tag:blogger.com,1999:blog-12233913.post111373291410982803..comments2023-04-16T04:17:43.152-07:00Comments on MySQL Tips: LOAD DATA INFILE example - importing data from csv into mysqlTravelTouristVideoshttp://www.blogger.com/profile/06397377314569093942noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-12233913.post-42324414413396083422011-09-19T01:34:45.987-07:002011-09-19T01:34:45.987-07:00Thank you so much - very helpful! My loaded csv fi...Thank you so much - very helpful! My loaded csv file data was appearing as zeroes and nulls until I read this blog and realised I hadn't specified the comma delimiter.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12233913.post-37586736164168928132011-09-13T13:53:27.377-07:002011-09-13T13:53:27.377-07:00But I got an error message:
ERROR 13 (HY000): Can&...But I got an error message:<br />ERROR 13 (HY000): Can't get stat of '/var/lib/mysql TAIR10_functional_descriptions_no_headers.txt.tab' (Errcode: 2)<br /><br />It is said related to the permission issue to mysql client or the user when I googled, but I checked the permission, it is rw-. Any clue? Thanks a lot!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12233913.post-7762484475023051882011-03-18T05:45:46.134-07:002011-03-18T05:45:46.134-07:00but that path with home what it means? where i nee...but that path with home what it means? where i need to place that file to take it?check oddshttp://www.checkyourodds.co.uk/noreply@blogger.comtag:blogger.com,1999:blog-12233913.post-72430548880690280182010-10-15T07:05:42.878-07:002010-10-15T07:05:42.878-07:00simple but excellent in the eyes of a newbie, ;-) ...simple but excellent in the eyes of a newbie, ;-) thxArend van der Kolkhttps://www.blogger.com/profile/17229127961440410465noreply@blogger.comtag:blogger.com,1999:blog-12233913.post-8417778529212083702010-07-04T14:22:21.278-07:002010-07-04T14:22:21.278-07:00Thanks very much. Very useful example.Thanks very much. Very useful example.Jasonhttps://www.blogger.com/profile/11109284081077590259noreply@blogger.comtag:blogger.com,1999:blog-12233913.post-46589492647826409762010-03-22T03:19:43.292-07:002010-03-22T03:19:43.292-07:00Thanks a lot.Thanks a lot.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-12233913.post-81275206368100116422009-12-14T18:23:36.046-08:002009-12-14T18:23:36.046-08:00Very good tip! Thanks!!Very good tip! Thanks!!MDMhttps://www.blogger.com/profile/09762627949644245232noreply@blogger.com