-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Matthew T. Adams wrote:
> Fair enough. However, the question remains:
>
> How do I do stuff (inserts, creates, updates) all in
> one round trip?
You don't (at least not in the way you think you might). However, MySQL
does have some things that allow you to do some of this stuff, like the
multi-value INSERT syntax I showed in the previous e-mail, the REPLACE
syntax (http://www.mysql.com/doc/en/REPLACE.html) which also supports
multiple values at a time which acts like an UPDATE or an INSERT
depending on the conditions.
>
> Does Connector/J support batching?
At the API-level, yes. But it doesn't do it in one network round trip,
because (as I said in the previous e-mail), MySQL before version 4.1
doesn't have this functionality, and it's not finished in 4.1 yet :)
Regards,
-Mark
- --
Mr. Mark Matthews
MySQL AB, Software Development Manager, J2EE and Windows Platforms
Office: +1 708 557 2388
www.mysql.com
Are you MySQL Certified?
http://www.mysql.com/certification/
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.3 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQE/e0motvXNTca6JD8RAj1fAKCFhhpVOruzKXJIcTlGm0OxZXraNQCdGjWj
icARPOo1SwyXjO5rI03Xppk=
=TEsI
-----END PGP SIGNATURE-----
