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.
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.
Comments
Software Development Company in Malaysia