Skip to main content

Posts

Showing posts from September, 2013

Sqlite3 101 - Know your table structure.

I commonly not used to manage any sqlite database but in situation that you've to do.. than you've to do that! Ok there's a new server that comes up for the development and I've missing the table of my sqlite database for the application. So how we gonna create the database ? It's quite simple. I've a server that already configured the database previously. #sqlite3 database.db "select * from sqlite_master"; then it will show the database structure which you can want to create. table|bandwidth|bandwidth|2|CREATE TABLE bandwidth (id INTEGER PRIMARY KEY,name text,created text,start real,end real) Noted for myself.