$ sqlite3 persons.db SQLite version 3.6.18 Enter ".help" for instructions Enter SQL statements terminated with a ";"
sqlite> create table person (id integer primary key, name string, age integer); sqlite> insert into person values(NULL, "Bharathi", 43); sqlite> insert into person values(NULL, "Raman", 23); sqlite> insert into person values(NULL, "Girish", 18); sqlite> select * from person; 1|Bharathi|43 2|Raman|23 3|Girish|18 sqlite> update person set age = 14 where name = "Girish"; sqlite> select * from person; 1|Bharathi|43 2|Raman|23 3|Girish|14 sqlite3 is a fantastic embedded database. It has none of the client server complications of mysql or postgres. Most open source projects use sqlite3 in some way or other. All webmail programs do. roundcube does. And my experience with it has been really pleasant though I learnt it only now. It has many bindings in many languages. Of course it can be accessed thro' perl, C, python, lua... -Girish -- Gayatri Hitech web: http://gayatri-hitech.com SpamCheetah Spam filter: http://spam-cheetah.com _______________________________________________ To unsubscribe, email [email protected] with "unsubscribe <password> <address>" in the subject or body of the message. http://www.ae.iitm.ac.in/mailman/listinfo/ilugc
