It\u2019s very common to insert data in multiple tables: a book followed by its author, a customer followed by their purchase, and so on. When doing this with an autoincrement column, you will need to retain the insert ID returned for storing in the related table.
For example, let\u2019s assume that these devices can be \u201csold\u201d to a person. New device is stored in the device table, we also want to create a key to tie it to the device to a owner. The code to do this is similar to that in, except that the returned insert ID is stored in the variable $insertID and is then used as part of the subsequent query<\/p>\n\n\n\n
Now the cat is connected to its \u201cowner\u201d through the devices unique ID, which was created automatically by AUTO_INCREMENT.<\/p>\n\n\n\n
Example for insert<\/a><\/p>\n","protected":false},"excerpt":{"rendered":" It\u2019s very common to insert data in multiple tables: a book followed by its author, a customer followed by their purchase, and so on. When doing this with an autoincrement column, you will need to retain the insert ID returned for storing in the related table.For example, let\u2019s assume that these devices can be \u201csold\u201d … Continue reading Using insert ID<\/span>