Teg-3 wrote > 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>
> sqlite-users@ > 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: > Teg@ > > _______________________________________________ > sqlite-users mailing list > sqlite-users@ > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users What do you mean that I want one protocol field?Sorry that I not very understand...can you give some example?thanks -- View this message in context: http://sqlite.1065341.n5.nabble.com/How-to-save-live-data-into-sqlite-database-using-c-language-tp68519p68544.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users