"Gilles" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > On Sat, 9 Feb 2008 08:41:56 -0500, "Igor Tandetnik" > <[EMAIL PROTECTED]> wrote: >> INSERT INTO phones (tel,id_customers) VALUES >> ('1234567',last_row_id()); > > Thanks, but I'm getting an error (FWIW, I'm using 3.5.4):
Sorry, it's last_insert_rowid() http://sqlite.org/lang_expr.html Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users