Put spaces around your = signs?
update swimmeet set start = "2008-11-20" where id = 1038;
Also, strings in SQL are delimted by single-quotes (') not double-quotes (").
Double quotes mean that the thing so contained is an ill-formed symbol (that
is, a table name, column name, etc) that contains ill-conceived characters
(like spaces, commas, etc), sort of like when quotes are required in Windoze
(and other OS's) because people used ill-conceived characters in directory and
filenames.
You might want to nip that bad habbit in the bud too before it bites you.
---
Theory is when you know everything but nothing works. Practice is when
everything works but no one knows why. Sometimes theory and practice are
combined: nothing works and no one knows why.
>-----Original Message-----
>From: sqlite-users-bounces at mailinglists.sqlite.org [mailto:sqlite-users-
>bounces at mailinglists.sqlite.org] On Behalf Of Skip Montanaro
>Sent: Saturday, 14 March, 2015 05:34
>To: sqlite-users at mailinglists.sqlite.org
>Subject: [sqlite] "=" should not be a word character
>
>I'm not sure where to report bugs/surprising behavior. The support page
>on
>the website doesn't mention a bug tracker.
>
>I use SQLite 3 mostly through the Python interface. I am working on a
>database where I'm adapting a huge crufty old spreadsheet with incomplete
>data. I am thus frequently in the sqlite3 shell. I'm an Emacs user, so
>was
>pretty comfortable right off-the-bat with what appears to be a GNU
>readline/history-based interface. I was surprised badly a few minutes
>ago. I
>needed to correct some dates (end date before the start date) and was
>using
>statements like
>
>update swimmeet set start="2008-11-20" where id=1038;
>
>Then I retrieved that statement with Ctl-P, then clear the id with Ctl-B
>ESC-Del. I then entered the id of the next record to correct, backed up
>and
>adjusted the date, and hit enter.
>
>Imagine my surprise when what I actually typed (without checking,
>obviously!) was something like this:
>
>update swimmeet set end="1991-04-21" where 4193;
>
>which updated the end date for every record! Thank goodness for version
>control and frequent commits...
>
>The problem is that the ESC-Del sequence deleted back much more than a
>word. It seems to me that the "=" should not be considered a word
>character.
>
>For reference, I am using /usr/bin/sqlite3 on a Mac running
>Yosemite:
>
>% sqlite3 --version
>3.8.5 2014-08-15 22:37:57 c8ade949d4a2eb3bba4702a4a0e17b405e9b6ace
>
>Thanks,
>
>Skip Montanaro
>
>
>_______________________________________________
>sqlite-users mailing list
>sqlite-users at mailinglists.sqlite.org
>http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
