I would like to assign null to a field in SQLite but am not getting anywhere with this:
update t set n=null where n=0; 
- 3What doesn't work? What is the error you get?user647772– user6477722012-10-26 08:46:11 +00:00Commented Oct 26, 2012 at 8:46
- 1Please add to your question: 1) The schema of your table, 2) some exaple data that already is in the table.user647772– user6477722012-10-26 08:49:21 +00:00Commented Oct 26, 2012 at 8:49
- 1are there any n==0 rows?Marcus– Marcus2012-10-26 08:59:08 +00:00Commented Oct 26, 2012 at 8:59
- 1@mrcalendar your code should work. Show the schema and values to help better. Answer Marcus questionnawfal– nawfal2012-10-26 09:10:43 +00:00Commented Oct 26, 2012 at 9:10
- 1@mrcalendar If schema and data are trivial, please add them to your question.user647772– user6477722012-10-26 09:17:54 +00:00Commented Oct 26, 2012 at 9:17
| Show 3 more comments
1 Answer
I can not reproduce your problem. From what you write, I guess your table looks like this:
CREATE TABLE t (n integer); Inserting data:
insert into t values (1); insert into t values (2); insert into t values (3); insert into t values (0); Updating the data with your UPDATE:
update t set n = null where n = 0; Now the table looks like this:
sqlite> .dump PRAGMA foreign_keys=OFF; BEGIN TRANSACTION; CREATE TABLE t (n integer); INSERT INTO "t" VALUES(1); INSERT INTO "t" VALUES(2); INSERT INTO "t" VALUES(3); INSERT INTO "t" VALUES(NULL); COMMIT; There might be no output after the UPDATE but it has the desired effect.