Re: DBI and MySQL not setting database properly

Does your statement work in the MySQL command line client?

I suspect your problem occurs because group is a reserved word in SQL. Maybe it works if you use the following form of the statement:

SELECT * FROM "group"
[download]

Comment on Re: DBI and MySQL not setting database properly Select or Download Code

Replies are listed 'Best First'.
Re^2: DBI and MySQL not setting database properly by KolassaRaptor (Monk) on Feb 24, 2016 at 17:19 UTC
You are absolutely right, it appears to be because of using a reserved word as my table name. I was able to query other table names that did not clash with reserved words just fine. The 'group' table just happened to be the first one that I had added to the database and thus the one that made me start prepending the database name. Well, chalk that one up to a learning experience. Thanks!	[reply]
Re^2: DBI and MySQL not setting database properly by chacham (Prior) on Feb 25, 2016 at 14:15 UTC
Just watch out, as quoting preserves case, which is not usually the case for unquoted names (which are usually uppercased).	[reply]