I’m looking to create a MySQL trigger on a table. Essentially, I’m creating an activity stream and need to log actions by users. When a user makes a comment, I want a database trigger on that table to fire and:
If I insert multiple records with a loop that executes a single record insert, the last insert id returned is, as expected, the last one. But if I do a multiple records insert statement:
It’s my understanding that when you call last_insert_id() it goes by connections, so you’ll get the id of the last row inserted on the same connection where last_insert_id() is called, right?
All queries execute successfully, when I check table in MySQL row inserted successfully without any error, but lastInsertId() returns 0. why?
Ok. So the short of it is, I was trying to do an INSERT SELECT such as:
Is there any built in function available in SQLite to fetch last inserted row id.
For eg :- In mysql we have LAST_INSERT_ID() this kind of a function. For sqllite any function available for doing the same process.
I’ve come across with a problem. My framework was working just fine with PHP 5.3.0. I upgraded my PHP version to PHP 5.4.x and I started to have few issues with some parts of my framework.
