Hello Sergiy,
On 07/25/2011 04:54 PM, Sergiy Nazarenko wrote:
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?
This does not seem to be HSQL specific. For mysql, Google gave me
LAST_INSERT_ID():
http://dev.mysql.com/doc/refman/5.0/en/information-functions.html#function_last-insert-id
There probably exist similar functions for other sql databases.
-- Steffen
_______________________________________________
Haskell-Cafe mailing list
Haskell-Cafe@haskell.org
http://www.haskell.org/mailman/listinfo/haskell-cafe
