From: http://blog.163.com/18_2/blog/static/2174448200851045114653/
Installation and Use of sqlite3 in Linux: Ubuntu online installation of sqlite3 database method: System Platform: ubuntu12.04
Run the following command in Ubuntu: sudo apt-Get install sqlite3 :........................ Libsqlite3-0 (= 3.7.9-2ubuntu1) But 3.7.9-2ubuntu1. 1 is to be installed ......
........................ My solution is to execute the following three commands in sequence: 1. sudo dpkg -- force-depends -- purge libsqlite3-0: i386
2. sudo apt-get-F install
3. sudo apt-Get install sqlite3
Read more: how to install SQLite 3 in Ubuntu | eHow http://www.ehow.com/how_8463512_install-sqlite-3-ubuntu.html#ixzz2U4yhrano
Http://askubuntu.com/questions/230619/cannot-install-sqlite3
16:51:14 | category: SQLite | font size subscription
1. installation and configuration of local sqlite3
Download the sqlite3 source code package
Tar xvfz sqlite-src-3.3.5
CD sqlite-3.3.5
./Configure-no-tcl
Make
(If you need to modify the makefile on the arm board, add-L/usr/local/ARM/3.3.2/lib to the libs item and save the file and exit. Then make)
After the installation is successful, the generated file will be copied to the specified directory.
Add another environment variable.
VI/etc/profile
Add sqlite3_path =/usr/local/sqlite-3.3.5 in the export region save and exit
Source/etc/profile
Useful files: $ sqlite3_path/include/sqlite3.h header files
$ Sqlite3_path/bin/sqlite3 Executable File
$ Sqlite3_path/lib/libsqlite3.a
Libsqlite3.la
Libsqlite3.so-> libsqlite3.so. 0.8.6
Libsqlite3.so. 0-> libsqlite3.so. 0.8.6
Libsqlite3.so. 0.8.6
When the program is used in the database
# Include <sqlite3.h>
Add the following in the. Pro file:
Includepath + = $ (sqlite3_path)/include
Dependpath + = $ (sqlite3_path)/include
Libs + =-L $ (sqlite3_path)/lib
Libs + =-lsqlite3
Save and exit
Tmake hello. Pro-O makefile
Make
Ii. programming:
Sqlite3 * dB;
Int rc = sqlite3_open ("Data. DB", & dB); // open the database data. DB
If (RC! = Sqlite_ OK); // opening failed
Create a table rc = sqlite3_exec (dB, "create table student (ID integer
Primarykey, name nvarchar (32) ", null, null, & mrrmsg );
Insert rc = sqlite3_exec (dB, "insert into student values ('3', 'zhangsan')", & mrrmsg );
Modify rc = sqlite3_exec (dB, "update student set name = 'Li si' where id = '4'", & mrrmsg );
Delete rc = sqlite3_exec (dB, "delete * from student where name = 'wang wu'", 0, & mrrmsg );
Query is the key
Debug query rc = sqlite3_exec (dB, "select * from student where ID> 2
And name <> 'zhangsan' ", loadinfo, null, & mrrmsg );
The query result is exported using the loadinfo function.
Typedef int (* sqlite3_callback) (void *, int char **, char **);
Int loadinfo (void * para, // DB
Int n_column, // number of record Columns
Char ** column_value, // locate the value
Char ** column_name) // field name
{
Int I;
Printf ("records contain % d fields \ n", n_column );
For (I = 0; I <n_column; I ++)
Printf ("field name: % s, field value: % s \ n", column_name [I], column_value [] I );
Return 0;
}
Function query rc = sqlite_get_table (dB, "select ID from student where ID> 2
And name <> 'zhangsan' ", & result, & nrow, & ncolumn, & errmsg );
Char ** result;
Int nrow, ncolumn;
Int RC;
Char * errmsg = NULL;
Rc = sqlite_get_table (dB, "select * from student where ID> 2
And name <> 'zhangsan' ", & result, & nrow, & ncolumn, & errmsg );
Int I;
Char ID [10];
Char name [10];
For (INT I = 1; I <= nrow; I ++)
{
Id [I] = Result [I * 2];
Name [I] = Result [I * 2 + 1];
}
Iii. sqlite3 command:
Sqlite3 data. DB // open data. DB
. Tables
. Schema output format
. Mode line/column/list // format single row, column, list
. Timeout // time
. Output test.txt // output to test.txt
. Q exit
Execute common SQL statements
[Root @ localhost root] # sqlite3 data. DB
SQLite> Create Table student (ID integer primary key, name nvarchar (32 ));
SQLite> insert into student values (1, 'Sun Wukong ');
SQLite> insert into student values (2, 'ang seng ');
SQLite> select * from student;
1 | Sun Wukong
2 | Tang Seng
SQLite> Update student set name = 'zhu Bajie 'Where id = '2 ';
SQLite> select * from student;
1 | Sun Wukong
2 | Zhu Bajie
SQLite> Delete from student where id = '2' and name = 'zhu Bajie ';
SQLite> select * from student;
1 | Sun Wukong
SQLite>. Tables
Student
Chinese support
[Root @ localhost root] # sqlite3 data. DB
SQLite> Create Table student (ID integer primary key, Name text); // Note: The name type is text.
SQLite> insert into student values (1, 'Sun wukong ');
SQLite> insert into student values (2, 'tangsan ');
SQLite> select * from student;
1 | Sun Wukong
2 | Tang Seng
SQLite> Update student set name = ' 'Where id = '2 ';
SQLite> select * from student;
1 | Sun Wukong
2 | pig
SQLite> Delete from student where id = '2' and name = 'pig ';
SQLite> select * from student;