How to set a field value null in sqllite?
#1

Hello Fellas how can i do that ^^ hmm take an example if a vip player can have alterate name so the db field is null in default but when the player uses a function in the gm it(alt name) will get in that field and now (this is prob) i guess i made a function to remove this altname and player used and i wanted the field to be back to null how can i do that what value should i add in
PHP код:
format(query,sizeof(query),"UPDATE data SET AltName = "here what value should i add to make it null" WHERE username = '%s'",DB_Escape(name)); 
Reply
#2

sorry for bump i need it quicker
Reply
#3

No one knows?
Reply
#4

Just set it to NULL and that's all you need.

SET `column`=NULL (without quotes)
Reply
#5

Thank very much +rep
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)