MySQL DB Connection

clm314159 has asked for the wisdom of the Perl Monks concerning the following question:

Hi, I'm trying to show someone how to connect to a MySQL DB with Perl. I've done this before but it was about 10 years ago. I know it is a pretty straight forward process except it is full of little details that must all be addressed. So my question is, Does anyone know of a good up to date tutorial for doing this on Windows? The ones I've been finding are either not for MySQL and there is the problem of interpreting the info from one DB to MySQL (currently I'm working from an oracle tutorial trying to install the driver, the oracle driver is clearly labelled as such but I cannot find a MySQL driver that is clearly labelled in the ppm) or the tutorial is 15 years out of date.

Any info you could point me at would be appreciated,

Comment on MySQL DB Connection

Replies are listed 'Best First'.
Re: MySQL DB Connection by hippo (Archbishop) on Sep 15, 2017 at 15:20 UTC
Since you haven't mentioned it, I'll point you to the DBI docs which are pretty extensive and the DBD::mysql docs for some MySQL specifics. If you are doing what those say but still getting problems, an SSCCE might be in order to see where the difficulties lie. Good luck.	[reply]
Re: MySQL DB Connection by marto (Cardinal) on Sep 15, 2017 at 15:21 UTC
DBD::mysql and it's INSTALL documentation are perhaps what you're looking for, see Binary installation. Strawberry Perl makes life much easier when working on Windows.	[reply]
Re: MySQL DB Connection by thanos1983 (Parson) on Sep 16, 2017 at 10:44 UTC
Hello clm314159, Welcome to the Monastery. Well the fellow Monks have pointed you to the right direction and you have resolved your problem. Since you have not worked with MySQL for some time I thought that maybe you are interested in some basic common functions e.g. create table, insert, retrieve etc. Take a look on a simple reply that I had posted in the past Re^7: extract column data. This is not a tutorial but it isa a small compiling example with the basics. I believe this can get you started. Hope this helps, BR. Seeking for Perl wisdom...on the process of learning...not there...yet!	[reply] [d/l] [select]
Re: MySQL DB Connection by clm314159 (Initiate) on Sep 15, 2017 at 22:11 UTC
Thanks for your help. We were able to get the connection working.	[reply]