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

[Sergiy Nazarenko]

Hi, everyone!

trycon <- connect "mysql" "bigtables" "vasya" "*******"
stmt' <- query trycon "INSERT INTO mytable (user,time,host,) VALUES
("Vasya","2011.07.30 11.59","foo")"

I am beginner to use HSQL and I have a problem.
I need to know row ID after INSERT into table.

fetch stmt'  returned False

What should I do?



Cheers!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.haskell.org/pipermail/haskell-cafe/attachments/20110725/75b4b04e/attachment.htm>