Bryan O'Donoghue wrote:
>The fact that MySQL may /let/ you away with it... doesn't necessarily
>make it *correct* or *portable* betwixt databases; !!!
>>If I'm not mistaken ... some versions of SQLite... may actually
>*enforce* this rule... !!
>>I'd like to argue that the semi-colon is completely redundant in PHP'
SQL calls. The semi-colon is used to delimit statements, and so is only
really needed when you are going to use another statement in the same
SQL call.
But - using multiple statements in single calls is an invitation for
injection attacks. So - no sane web-accessible language should allow
multiple statements, and therefore, it is never necessary to delimit
them (so semi-colons are not needed).
Kae
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!