On Thu, Jun 24, 2010 at 12:34:18PM -0500, Peng Yu scratched on the wall: > According to The Definitive Guide to SQLite (page 120), if I type > "select null=null;" in a sqlite3 session, I should get 'NULL' printed. > > http://apress.com/book/view/9781590596739 > > But I tried it in sqlite3, only an empty line is printed. Is it the > cases that sqlite3 change the way to show null after the book was > published?
Likely. See sqlite3 command ".nullvalue". -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important that you have it, but showing it to the wrong people has the tendency to make them feel uncomfortable." -- Angela Johnson _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users