On Sun, Oct 14, 2012 at 9:01 AM, Gary Jeurink <[email protected]> wrote: > I'm trying to populate mysql tables from my foxpro tables. The best I have > done is to export to text delimited files then use LOAD DATA command and it > does okay except I can't get the dates to go. I'm guessing they need to be > formatted some how. A row of text delimited looks like > > "DUKE",09/01/2012,"FLA INT",46,26,F,5796,"01" > > Then when I check the mysql table, everything is there but the dates read > 000-00-00. (2012 COLLEGE FOOTBALL GAMES) ---------------
Is that F for a logical False? -- Stephen Russell Sr. Analyst Ring Container Technology Oakland TN 901.246-0159 cell _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CAJidMY+TGpLj__M5nOVt0c1bVSQzgE=ueqzrr0fw0e-ev8t...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
