Discussion Locked

Various Questions related to mySQL

0 helpful
4 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello, I am in the beginning stages of learning mySQL and C#. I have some questions.

1) How difficult is it to get the .net and CLS architecture that MS has made to work with the open source mySQL?

2) How can I change mySQL so I can dump a file into mySQL using a delimeter of my chosing (for example I would like to use \ as delimeters rather then TABs)

Any help would be very appreciated, thank you.

4 replies

by Lamont Adams

I'm not speaking from experience, I've never used MySQL, but, assuming that MySQL is ODBC-compliant (I believe it is) I don't imagine there'd be any problem with using it with .NET, or any other MS product, as long as you stayed with basic functionality.

I'll let someone with some specific experience answer your other question.

by shelleydoll

I don't think MySQL itself has that feature, but I did find one interface tool that claims to. (I'm sure it does the dump then replaces the delimiters.) Let me know if it works: http://www.polarlava.com/myclient/docs/

Also, if you use phpMyAdmin (http://www.phpmyadmin.net), you have the option to create a CSV of a table with your choice of delimiter. Also, this is nice because you can get rid of the /n/r line terminator (change it to just /n, for example) if you've run into that problem on Windows.

by mullin

There is a feature in mySQL to decide which deliminator to use.

Normally loading data from a text file would be done by

load data infile 'filename.txt' into table tablename;

however if you add on "field terminated by ','"

Thank you foryour help

This discussion is closed to new replies.