1 sqlite 安装

1. 下载

2. sqlite安装

   tar zxfv sqlite-autoconf-3070701.tar.gz

3. 安装三步骤

//如果不加--disable-tcl，在编译的时候会出错
ywx@ywx:~/yu/sqlite/sqlite-autoconf-3070701$ ./configure --disable-tcl
ywx@ywx:~/yu/sqlite/sqlite-autoconf-3070701$ sudo make
ywx@ywx:~/yu/sqlite/sqlite-autoconf-3070701$ sudo make install

被安装到了 /usr/local/ 下， 其中 执行文件在 ./bin/sqlite3
                                 链接库在 ./lib/libsqlite3.so.0

   但是当我执行 文件时出错了

ywx@ywx:/usr/local/bin$ sqlite3
SQLite header and source version mismatch
2010-08-23 18:52:01 42537b60566f288167f1b5864a5435986838e3a3
2011-06-28 17:39:05 af0d91adf497f5f36ec3813f04235a6e195a605f

4. 解决方法；
   参考：

apt-cache search build-essential
apt-get install build-essential

ywx@ywx:~/yu/sqlite/sqlite-autoconf-3070701$ ./configure --disable-tcl
ywx@ywx:~/yu/sqlite/sqlite-autoconf-3070701$ sudo make
ywx@ywx:~/yu/sqlite/sqlite-autoconf-3070701$ sudo make install
root@ywx:/home/ywx/yu/sqlite/sqlite-autoconf-3070701# ldconfig

 查看

ywx@ywx:/usr/local/bin$ ls
pcap-config  sqlite3
ywx@ywx:/usr/local/bin$ ./sqlite3
SQLite version 3.7.7.1 2011-06-28 17:39:05
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>