On Tue, 26 Oct 2004, Murphy, Ged (Bolton) wrote: > Going back a few years here, but does an SQL statement not have to end > in a semi-colon as above?
I think it depends on your SQL interpreter. The MySQL command line interface `mysql` expect semi-colons, as does the `psql` tool for PostgreSQL. I seem to remember that Oracle's `sqlplus` did as well, but I'm not sure about other database engines. As for DBI though, for single-statement queries, it doesn't matter, does it? My impression was that DBI scripts worked both with or without the semi-colon, but maybe this depends on the DBD being used. In any case, I've written DBD::mysql code that worked fine without it... -- Chris Devers -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] <http://learn.perl.org/> <http://learn.perl.org/first-response>
