I am trying to make a function that can select id from my database table and I have some questions.
Q1 : If I insert 5 data in my database and i delete from the second data. What is the ID be when i insert the next data ?
Table sample :
ID | NAME |
0 | A |
1 | B |
2 | C |
3 | D |
4 | E |
Q1: If ID column is Auto Incremental, then when you delete any row your next id will be incremented even if you delete last row (i.e. if you delete 6th row then next row ID will be 7)
Q2: Throws exception Column does not exist.
Q3: Returns empty rows