Shulou(Shulou.com)06/01 Report--

Editor to share with you how to use the SQLite database under Ubuntu 12.04, I believe most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

A simple example of SQLite development under Ubuntu 12.04 is as follows:

1. Install SQLite3

Hadron@hadron ~ $sudo apt-get install sqlite sqlite3

2. Check the version number

Hadron@hadron ~ $sqlite3-version

3. Create a test database

Hadron@hadron ~ $sqlite3 test.db

SQLite version 3.7.9 2011-11-01 00:52:41

Enter ".help" for instructions

Enter SQL statements terminated with a ";"

Sqlite >

4. View the database

Sqlite > .database

Seq name file

0 main / home/hadron/test.db

5. Create a data table

Sqlite > create table user (id,username,password)

6. Insert data

Sqlite > insert into user (id,username,password) values (1)

7. Query data

Sqlite > select * from user

1 | abc | 123

8. Exit the database

Sqlite > .exit

9. Enter the database again

Hadron@hadron ~ $sqlite3

SQLite version 3.7.9 2011-11-01 00:52:41

Enter ".help" for instructions

Enter SQL statements terminated with a ";"

Sqlite >

10. Install visualization tools:

Hadron@hadron ~ $sudo apt-get install sqlitebrowser

These are all the contents of this article entitled "how to use SQLite Database under Ubuntu 12.04". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.