good point. And probably better documented. **opens google** Dana
William Bowen writes: > heh... SQL Server also provides for "other" delimiters. I like the idea of > writing a CF page to loop over the file and then insert that into the > db...saves time. > > will > > > ----- Original Message ----- > From: "Dana Tierney" <[EMAIL PROTECTED]> > To: "CF-Community" <[EMAIL PROTECTED]> > Sent: Friday, June 06, 2003 2:57 PM > Subject: Re: import > > > > mm no it's | delimited but that's easy enough to fix. I dunno if there is > > an import data function in mysql...I suppose I could always go look at the > > manual....see if import comes up in the index.... > > > > duh > > > > Dana > > > > William Bowen writes: > > > > > is it comma delimited? > > > > > > is there an import data function similar to SQL Server 7.0/2000? > > > > > > will > > > > > > ----- Original Message ----- > > > From: "Dana Tierney" <[EMAIL PROTECTED]> > > > To: "CF-Community" <[EMAIL PROTECTED]> > > > Sent: Friday, June 06, 2003 12:17 PM > > > Subject: import > > > > > > > > > > I didn't get an answer to this on talk, let me try you guys. I have > data > > > in > > > > a bunch of text files, where fields are delimited by | characters > (user > > > > data from a Perl bulletin board). I would like to put this data into a > > > > mysql database... Surely there is a better way than cut and paste? > > > > > > > > Dana > > > > > > > > But I don't make films > > > > But if I did they'd have a samurai - Bare Naked Ladies > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=5 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=5 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
