ansaurus

Question

Answer 1

+5 A:

SELECT * FROM tooVague;
SELECT * FROM googleIt;

Stefan Kendall 2009-10-22 20:22:43

lol :). I Thought left join may have to do with it but this is simple :) +1 and answered.

An employee 2009-10-22 20:25:38

And this is one statement? ;-)

IronGoofy 2009-10-22 20:39:29

If you're using the Connector/J JDBC driver, you have to give it permission to run multiple queries in a single request.http://dev.mysql.com/doc/refman/5.0/en/connector-j-reference-configuration-properties.htmlScroll down to Security > allowMultiQueries.

iKnowKungFoo 2009-10-22 20:42:06

Link for MySQL 4:http://dev.mysql.com/doc/refman/4.1/en/connector-j-reference-configuration-properties.html

iKnowKungFoo 2009-10-22 20:44:42

Answer 2

A:

If the question is "Can I execute two commands in one query?" then the answer is "no."

iddqd 2009-10-22 20:35:26

Any reason this was downvoted? If you're going to downvote, at least tell me how I'm wrong.

iddqd 2009-10-23 18:08:59

I didnt do it but i assume the answer is yes and no is wrong?

An employee 2009-10-26 12:57:12

ansaurus

tags:

views:

answers:

Mysql 2 queries in one?

related questions