I want to have the image I'm uploading have the ID of the row it belongs to as the name (e.g. 42.jpg) to ensure uniqueness.
Is it possible to get this in the middle of the query? Or do I have to get the ID after then update the row?
Asked
Active
Viewed 56 times
0
Doug Smith
- 29,668
- 57
- 204
- 388
-
5If it is always equal to `id` - why to store it twice? – zerkms Jul 18 '14 at 22:41
-
If you want uniqueness, use a GUID. – Tieson T. Jul 18 '14 at 22:41
-
Are you storing a BLOB or path to the filename? – aland Jul 18 '14 at 22:46
-
This probably isn't a great idea. – Strawberry Jul 18 '14 at 22:47
-
possibly related http://stackoverflow.com/a/1405500/3574819 – FuzzyTree Jul 18 '14 at 22:47
2 Answers
3
You could first insert an empty row (with a null image and filename.) You can retrieve the last inserted ID with LAST_INSERT_ID().
After that, you can update the row with the image and the file name based on the ID.
Andomar
- 232,371
- 49
- 380
- 404
0
If id is AUTO_INCREMENT column in the table you're inserting... no, the automatically assigned value is not available during statement execution. And the value isn't available when a BEFORE INSERT trigger is fired.
The value assigned to the row is only available after the INSERT statement completes.
Immediately following a successful insert, SELECT LAST_INSERT_ID() (equivalent library function) can retrieve the value assigned.
As another option, you could consider emulating an Oracle sequence object, using a separate table with an AUTO_INCREMENT column, and LAST_INSERT_ID. If you get that as a unique id before you do the INSERT, you could supply the value in the INSERT.
spencer7593
- 106,611
- 15
- 112
- 140