[Haskell-cafe] Fwd: Re: How to select last inserted record from Table Using Database.HSQL.MySQL

Forwarding to list -------- Original Message -------- Subject: Re: [Haskell-cafe] How to select last inserted record from Table Using Database.HSQL.MySQL Date: Tue, 26 Jul 2011 14:27:56 +0300 From: Sergiy Nazarenko To: Steffen Schuldenzucker Thanx a lot! I could solve that problem in this way: cmd = " INSERT INTO mytable (bar,foo) VALUES ("val1","val2"); SELECT LAST_INSERT_ID() as id;" lst <- query connection cmd >>= collectRows (\st -> getFieldValue st "id") lst has required value Cheers!