Re: [sqlite] How to design this table?

> Simon Slavin writes: > On 9 Oct 2011, at 3:57am, 张一帆 wrote: >> i have some data like "a and b or c ...",there will be a word 'and' >> or 'or' which means the Logical relations between each item. > If you have "a and b or c" does that mean > (a and b) or cOR > a and (b or c)

Re: [sqlite] How to design this table?

张一帆 wrote: > i have some data like "a and b or c ...",there will be a word 'and' or > 'or' which means the Logical relations between each item.So how to design a > table to store the data in best way? Best way to achieve which goals? What operations do you need to perform on

Re: [sqlite] How to design this table?

> > i have some data like "a and b or c ...",there will be a word 'and' or > > 'or' which means the Logical relations between each item. > If you have "a and b or c" does that mean > (a and b) or c OR > a and (b or c) ? > How does your software know ? > Simon. just a and b or c...,like

Re: [sqlite] How to design this table?

On 9 Oct 2011, at 3:57am, 张一帆 wrote: > i have some data like "a and b or c ...",there will be a word 'and' or > 'or' which means the Logical relations between each item. If you have "a and b or c" does that mean (a and b) or cOR a and (b or c)? How does your software know ? Simon.

[sqlite] How to design this table?

i have some data like "a and b or c ...",there will be a word 'and' or 'or' which means the Logical relations between each item.So how to design a table to store the data in best way? ___ sqlite-users mailing list sqlite-users@sqlite.org