Java statement, Load Data return generated keys
My question may be very simple, but I cannot find an answer to it.
If I execute statement.execute("LOAD DATA ...")
, it will generate return keys exactly like INSERT
Statement.
If I don't want to receive any return value from the operator LOAD DATA
, I have to execute:
statement.execute("LOAD DATA ...",Statement.NO_GENERATED_KEYS)
or is it unnecessary since statement.execute("LOAD DATA ...")
it won't return any keys in this case?
+3
Michael
source
to share
1 answer
- You must use
Statement.executeUpate()
forLOAD DATA
- If you don't need return values then use
Statement.executeUpdate("LOAD DATA..", Statement.NO_GENERATED_KEYS)
0
Pradeep pati
source
to share