Using the (simple)
JDBC code below, I can't seem to create temporary table...
String tmpTableCreateSQL = "CREATE TEMPORARY TABLE IF NOT EXISTS tmpTable select * from customer";
boolean success = statement.execute(tmpTableCreateSQL);
>>>> success always returns false. <<<<<
I'd like to be able to get the temp table with something like:
ResultSet temp = statement.getResultSet();
And then manipulate it with UPDATE statements and such.
=====
Why isn't the initial statement returning true? I have lots of customer records and issuing this in an interactive tool works OK.
Thanks in advance.
- Mike