On 8/21/09 14:18 , "shakeeb khan" <khanshak...@msn.com> wrote:
> tell me what is a proper way of > creating database in sqllite Here is a sample terminal session on my Mac (possibly very poorly reformatted by my mail client): jdmbook:~ klee$ sqlite3 mydb.db SQLite version 3.6.12 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> .databases seq name file --- --------------- ---------------------------------------------------------- 0 main /Volumes/Prune/Users/klee/mydb.db sqlite> create table test (id integer, name char(256), tel char(32)); sqlite> select * from test; sqlite> insert into test (id, name, tel) values (1, 'John Doe', '555-1234-5678'); sqlite> select * from test; 1|John Doe|555-1234-5678 sqlite> I hope that helps, Jean-Denis _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users