I've made this design similar to my problem, it's not exact but it close enough to understand my problem:

enter image description here

Some cellular client frequently send their GPS position and the WLAN name that they have in range, sometimes only their position.

I've auto-generated timestamp and auto-incremental idModelGPS from ModelGPS table and I'm using javaDB to write to the DB.

I want to link the ModelGPS to an WLAN name where it happens, but I can't do it because the idModelGPS is autogenerated. I cannot access it to write in the ModelGPS_WLAN table.

I don't know how to handle this, maybe there is a design error or maybe there is a way to solve this problem that I'm unaware of. I'll be glad to hear your opinions.

  • This sounds like you need a query more than expert level help, which would be the domain of Stack Overflow, but I'm having a hard time parsing your problem. Can you provide us with some sample table DDL, and maybe the query DML you're having troubles with? – jcolebrand Feb 6 '12 at 16:24

So you just need to fetch the last auto-increment value that was inserted? There are a couple of ways to do this, but they're all pretty simple.


php mysql: $id = mysql_insert_id($mysql_conn);

php mysqli: $id = $mysqli->insert_id;

Both of those links have some example code that looks pretty easy to follow.

  • But this solution allows that other thread makes an insert after your insert and before your select and this can make you take an ID that is not this you want, that's the problem I have – Rigal Feb 7 '12 at 9:18
  • The LAST_INSERT_ID() function is scoped to an individual connection/process. If connection A inserts a new auto-increment value, then connection B does the same, connection A will get the value that it inserted when evaluating LAST_INSERT_ID() (and likewise for connection B). As long as the connection retrieves that value immediately after inserting, you shouldn't have to worry about race conditions. – db2 Feb 7 '12 at 13:28

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.