Timeline for Update Mysql records using Same table but Based on same table record
Current License: CC BY-SA 4.0
5 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Oct 17, 2019 at 5:04 | vote | accept | 5a01d01P | ||
| Oct 16, 2019 at 13:14 | answer | added | Akina | timeline score: 0 | |
| Oct 16, 2019 at 13:03 | comment | added | KevH |
Without any way to link the separate entities to their variables there is no way to update this after the data has been entered. Your options are to add the wishlist ID at the time you do the initial INSERT or restructure your tables so that they work in a normalised way and keep the relevant data in separate tables linked by the wishlist_id
|
|
| Oct 16, 2019 at 13:02 | comment | added | Akina |
Does id can be used to identify the records where wishlist value must be populated? does all records with name != 'wishlist' have wishlist IS NULL?
|
|
| Oct 16, 2019 at 12:39 | history | asked | 5a01d01P | CC BY-SA 4.0 |