On 7 Jan 2020, at 7:13pm, Andy <borucki.andr...@gmail.com> wrote: > But it is variable number this fields and column are strictly defined. Maybe > all in one Sqlite text field or define for example 10 field which often will > empty?
Parent Child database. One table has one entry per message. The other table has one entry per header. This is a natural conclusion for anyone uses SQL. I suggest you pause the work on your project and read some SQL tutorials. Read how relational databases work. This is about SQL, no matter which implementation. It is the same for SQLite, MS SQL, MySQL, and all other implementations of SQL. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
