How i can start id a value 100 | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

How i can start id a value 100

24th Jan 2019, 8:49 PM
Abdelhamid EL KEMMAL
Abdelhamid EL KEMMAL - avatar
3 Answers
+ 1
You mean if the value of ID is null? If so, try something like this SELECT NVL(ID,100) FROM TABLE;
26th Jan 2019, 5:38 AM
Enrique Morales
Enrique Morales - avatar
+ 8
You mean “add a value 100”?
25th Jan 2019, 1:28 AM
JTLZ
+ 2
EL KEMMAL Abdelhamid, Your question is not clear, try to reassamble your question or give a attempt to explain your question abit more. Something like this? SELECT * FROM `table` WHERE id='100'; If you trying to increment an id, make sure you set it to auto_increment or make an additional row for incremention.
25th Jan 2019, 1:37 AM
🌴Vincent Berger🌴
🌴Vincent Berger🌴 - avatar