FYI: @@IDENTITY

2002-05-29 Thread Richard Davidson
I don't know if this is just weirdness on my system but I thought I would pass this on in case anyone runs into this problem. I'm converting some Java/JDBC code from a commercial DBMS to MySQL. The existing code executed the SQL statement "Select @@identity" after an INSERT to retrieve the autoi

Read Only on User table

2002-05-24 Thread Richard Davidson
Hi, I'm rather new to MySQL and trying to figure out GRANT and REVOKE so a password is required for access. Both GRANT and REVOKE give errors saying "Table 'User' is read only". A text search in the manual for "read only" did not yield anything. Is this an OS attribute that should be dealt with ma

Newbie question: Which is better InnoDB or BDB?

2002-05-23 Thread Richard Davidson
Hello, I'm new to MySql. I plan to switch my Java/JDBC web application to use MySql. The application requires transactions so, as I understand it, I need the table types to be BDB or InnoDB. Can anyone offer comments on which file type is preferred? Is one more stable than another? Is there a sign