How i can start id a value 100 | Sololearn: Learn to code for FREE!
Novo curso! Todo programador deveria aprender IA generativa!
Experimente uma aula grƔtis
+ 1

How i can start id a value 100

24th Jan 2019, 8:49 PM
Abdelhamid EL KEMMAL
Abdelhamid EL KEMMAL - avatar
3 Respostas
+ 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