Re: how perl can connect with mysql

You need at least two things:

a colon (:) between "mysql" and "test1". It seems there is a strange character instead (that was before you updated your code).
An appropriate driver (DBD::mysql), without which the DBI can't know which DBMS it should talk to.
If you want to know if the driver is already installed, use this line:
```
$ perl -MDBD::mysql -e 1
[download]
```
If no error is returned, then you have the right module installed. If you get an error message, you should install it.

HTH

Comment on Re: how perl can connect with mysql Download Code

Replies are listed 'Best First'.
Re^2: how perl can connect with mysql by biofeng918 (Acolyte) on Jan 09, 2005 at 13:05 UTC
I have installed the DBD-mysql by the way of internet. So it should be the most appropiate one for this version perl.	[reply]
Re^3: how perl can connect with mysql by cchampion (Curate) on Jan 09, 2005 at 14:11 UTC
So now you have amended your code and made sure that the DBD module is installed. Did you try again running the code? If yes, does it work? If not, does it give you any messages? Help us to help you. Please read (and practice) Before asking a database related question .... Oh, BTW, (I forgot the Monastery mantra) use strict and warnings, and a lot of errors will fall in you net without much effort.	[reply]
Re^4: how perl can connect with mysql by biofeng918 (Acolyte) on Jan 09, 2005 at 15:07 UTC
I have run the code after amending, but it still didnot work,it says that syntax eeror at line8 near "insert itnto insert into mytable (name,sex,birth,birthaddr)" and ( might be a runaway multi-line >> string starting on line4) ,unmatched right curly bracket at line8,at end of line. So this is all I know now,thank you again.	[reply]