Re^3: List columns for a MySQL table

[jZed]

Sorry, you're wrong. AFAIK, no DBI driver requires a semicolon at the end of a SQL statement and many will throw an error if you put one in (though DBD::mysql seems to allow, but not require it).

update : To quote from the DBI docs: "Some command-line SQL tools use statement terminators, like a semicolon, to indicate the end of a statement. Such terminators should not normally be used with the DBI."

[EvanK]

despite what the DBI docs say, every query i run through DBD::mysql fails unless its terminated with a semicolon. mabye theres something strange about the server i'm on, though :shrug:

edit: could be that i'm using mysql 5.0, which has some...oddities with DBD::mysql