sqlite3 double quote behavior

Roel Schroeven roel at roelschroeven.net
Tue Dec 13 16:44:37 EST 2022


Roel Schroeven schreef op 13/12/2022 om 22:36:
> sqlite> insert into foo values ("xyzzy", "xyzzy");
SQLite accepts it like that, but I really should have used single quotes 
there instead of double quotes. It's a bad habit from using MySQL for 
too long I guess.

-- 
"In the old days, writers used to sit in front of a typewriter and stare out of
the window. Nowadays, because of the marvels of convergent technology, the thing
you type on and the window you stare out of are now the same thing.”
         -- Douglas Adams



More information about the Python-list mailing list