On May 6, 2009, at 7:03 AM, Maria wrote: > thanks for quick reply. > >> ./sqlite3 test.db > it's working. does it mean that when I use '>sqlite3 test.db', it's > not > working from the source code??
When you type just "sqlite3", the shell searches the directories on your PATH environment variable and runs the first instance of the "sqlite3" program that it finds. It is probably running an sqlite3 that you have installed in /usr/bin or /usr/local/bin, therefore. If you want to run the version of sqlite3 that you just compiled, you have to either (1) put directory "." on your PATH prior to /usr/bin or /usr/local/bin or (2) specify an explicit pathname the copy you just compiled. Years ago (decades ago, actually) most people had directory "." as the first element of their PATH. But that practice is now considered poor security since it allows bad guys to put mischievous programs named like "mv" or "cp" in the local directory and trick you into running them. And so "." is not commonly found on PATHs anymore. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
