On Mon, Jun 26, 2006 at 08:33:34PM +0100, Simon Riggs wrote:
of the SQL standard, so being unaware of them when using SQL is strangeto me.
Welcome to the world of programs designed for mysql. You'll almost never see them batch inserts, take advantage of referential integrity, etc. You end up with lots of selects & inserts in loops that expect autocommit-like behavior because it doesn't matter in that world.
Mike Stone