Re: [sqlite] retrieve by name or index

2016-07-04 Thread R Smith
On 2016/07/04 12:22 PM, Jim Wang wrote: hi,all There is a table include id,string1,string2 and so on. So I want to get the value of string1 from a record, there are two methods: 1. get by the name of the string2 2. get by the index of the string2, the index is 2 which

Re: [sqlite] retrieve by name or index

2016-07-04 Thread Simon Slavin
On 4 Jul 2016, at 11:22am, Jim Wang <2004wqg2...@163.com> wrote: >There is a table include id,string1,string2 and so on. >So I want to get the value of string1 from a record, there are two methods: >1. get by the name of the string2 >2. get by the index of the string2, the

[sqlite] retrieve by name or index

2016-07-04 Thread Jim Wang
hi,all There is a table include id,string1,string2 and so on. So I want to get the value of string1 from a record, there are two methods: 1. get by the name of the string2 2. get by the index of the string2, the index is 2 which one is faster?