I'm familiar with SQL Server and Oracle, but not MySQL. I suggest you follow DGraham's search results, or google for MySQL, auto increment, primary keys.
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, January 27, 2005 11:23 AM To: Struts Users Mailing List Subject: [OT] Re: Another ODBC OT Question I googled this: http://www.google.com/search?sourceid=navclient&ie=UTF-8&rls=GGLD,GGLD:2004- 11,GGLD:en&q=jdbc+mysql+auto%5Fincrement and found this: http://dev.mysql.com/tech-resources/articles/autoincrement-with-connectorj.h tml It was too easy, so it's probably the wrong thing. Brandon Mercer <[EMAIL PROTECTED]> 01/27/2005 01:17 PM Please respond to "Struts Users Mailing List" <user@struts.apache.org> To Struts Users Mailing List <user@struts.apache.org> cc Subject Re: Another ODBC OT Question Barnett, Brian W. wrote: >What rdbms are you using? > > Sorry, that would have been helpful huh! lol MySQL Connector/J (obviously) 3.0.x. I think I know how to get the last id... but do I create another insert the same way I did the first? Thanks, Brandon --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
