Answer: How can I see error messages from MySQL?


Syntactic Confectionery Delight
	PerlMonks

Answer: How can I see error messages from MySQL?

by BBQ (Deacon)

on Jul 10, 2000 at 09:59 UTC ( #21753=categorized answer: print w/replies, xml )

Need Help??

Q&A > database programming > How can I see error messages from MySQL? - Answer contributed by BBQ

DBI has return values for each one of its calls, so it would be wise to or your connect statement, like:

$dbh = DBI->connect("DBI::mysql ... etc $dsn") 
    or die("Couldn't connect to $dsn: $DBI::errstr\n");
[download]

this way, you'll always get an error message if something goes wrong.

Comment on Answer: How can I see error messages from MySQL? Download Code

Log In^?

Chatterbox^?

How do I use this? | Other CB clients

Other Users^?

Others drinking their drinks and smoking their pipes about the Monastery: (4)

As of 2020-09-27 23:11 GMT

Sections^?

Information^?

Find Nodes^?

Leftovers^?

Voting Booth^?

If at first I don’t succeed, I …

Results (143 votes). Check out past polls.

Notices^?