note 73788 deleted from function.mysql-query by sp
| From: | sp@php.net | Date: | Sat, 24 May 2008 20:58:27 +0000 |
| Subject: | note 73788 deleted from function.mysql-query by sp | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-139713@lists.php.net to get a copy of this message | ||
Note Submitter: x_terminat_or_3 at yahoo dot fr
----
It says in the manual:
The query string should not end with a semicolon.
However, I read somewhere that it is good practice to add a semicolon at the end of your query, and
that it increases security against SQL-injection attacks. Therefore I have issued a requirement that
all my developers end queries with semicolons.
So far, PHP & MySQL have happily accepted those queries, with only one exception:
If you use more then one query in the same call to mysql_query, MySQL sometimes only executes the
first query and fails on the others.