Hello Newbie89, Sunday, April 28, 2013, 3:32:07 AM, you wrote:
N> Thanks for the correction N> ok...I will check first. N> -- N> View this message in context: N> http://sqlite.1065341.n5.nabble.com/How-to-save-live-data-into-sqlite-database-using-c-language-tp68519p68521.html N> Sent from the SQLite mailing list archive at Nabble.com. N> _______________________________________________ N> sqlite-users mailing list N> [email protected] N> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users I suspect you want one protocol field enum _protocols { C_PROTOCOL_TCP, C_PROTOCOL_UDP, ...... }; CREATE TABLE host ( Src_MAC char(18), Src_IP char(16), Cap_Bytes integer, Protocol integer, .... ); With a single protocol tag per insert. Then you tag each packet insert with the protocol field. -- Best regards, Teg mailto:[email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
