当字段UID值为NULL时，如何为sqlite字段分配序列值 [英] How Can I assign a sequence value to a sqlite field when the field UID value is NULL

问题描述

例如，如何为现有的sqlite表中的NUll字段"UID"分配序列值

How I can assign a sequence value to a field "UID" which is NUll in existing sqlite table, for example

table: FOO  
name    UID
A   1
B   2
C   100
D   NULL
E   NULL
F   NULL

我想要的是

table: FOO  
name    UID
A   1
B   2
C   100
D   101
E   102
F   103

一些身体可以帮忙吗? 我想根据我的原因寻求使用自动增量的替代方法...

Can some body help? I want to seek an alternative for using autoincrement on my own reason...

谢谢！

推荐答案

注册函数返回它被调用的次数，然后执行

Register a function that returns the number of times it's called, and then do

UPDATE FOO SET UID = 100 + increment() WHERE UID IS NULL

这篇关于当字段UID值为NULL时，如何为sqlite字段分配序列值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！