Quote it:
sqlite> create table x(in);
Error: near "in": syntax error
sqlite> create table x("in");
sqlite> insert into x values(1);
sqlite> select * from x;
1
sqlite> select in from x;
Error: near "in": syntax error
sqlite> select "in" from x;
1
sqlite> update x set in=3;
Error: near "in": syntax error
sqlite> update x set "in"=3;
sqlite> select "in" from x;
3
Michael D. Black
Senior Scientist
Advanced Analytics Directorate
Advanced GEOINT Solutions Operating Unit
Northrop Grumman Information Systems
________________________________
From: [email protected] [[email protected]] on
behalf of [email protected] [[email protected]]
Sent: Wednesday, June 27, 2012 11:20 AM
To: [email protected]
Subject: EXT :[sqlite] How do I rename a column called IN?
Hi all,
I am no programmer, and I only know a small number of very basic SQLite
commands, and I have a serious problem: I need to change values in a column
that some fool named IN like the operator (I think IN is an operator).
Normally, I use the command line
UPDATE name_of_table SET xyz=10 WHERE xyz<10;
in order to change values in a column, and it works well, and that's all I ever
need to do. However, everytime I try to access this particular column called
IN, I get errors that I believe are due to the column's name. The column can be
read but not modified. Is there a way to address and to change the values in
it? It was obviously created but how can I change it?
Regards,
Martin
--
Ihr WEB.DE Postfach immer dabei: die kostenlose WEB.DE Mail App für iPhone und
Android.
https://produkte.web.de/freemail_mobile_startseite/
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
