note 78808 deleted from function.mysql-query by felipe

Note Submitter: Max ---- Re: no support for multiple queries. Some have suggested that multiple queries are not supported in order to avoid people being able to drop tables. This seems a weak argument to me, since security should be handled on the server. Why not create and use a user that doesn't have the required permissions? I find a need to use a temporary table. Without multiple queries, they're impossible. An alternative is to use a real table, which means I need to increase the permissions for the user I am using (which was previously read-only). So, it would seem that, in my case, not supporting multiple queries has opened a security hole, not closed one. In fact, it's plausible that one might not even have the authority to change a user's permissions, so this would mean the only alternative is to use a sub-query, which is quite a bit slower (according to my testing on mysqld5), and even crashes mysqld4.