about innodb_flush_log_at_trx_commit

Hi all, I've been looking at the performance of mysql using innodb tables and I've noticed that I can get a huge benifit by setting innodb_flush_log_at_trx_commit = 0. The documentation warns me that I can loose a couple of seconds of transactions in system crash if I do this. It seems like a gr

documentation on error codes

I'm getting an error trying to create a table but can't find any error codes listed in the online mysql documentation. Does anyone know a good source for this? Also is the cause of my error recognisable to anyone? I just successfully created the tables listed but this one bounced. All tables are

foreign key syntax parsing errors

Below I have two queries. They both should do the same thing but the foreign key syntax is a little different. The first query fails, though some queries with foreign key clauses work sometimes, and the second one just works. Am I right in thinking the syntax for both these queries mean the same