Re: [sqlite] how to get the records matching some two characters?

Thanks! This is what I need, :) Jay A. Kreibich-2 wrote: > > On Mon, Aug 31, 2009 at 06:33:08PM -0700, liubin liu scratched on the > wall: >> >> create table and index： >> CREATE TABLE data_rt ( id INTEGER, dataid CHAR(4), data CHAR(12), >> rec_time >> INTEGER, data_type CHAR(1) ); >> CREAT

Re: [sqlite] how to get the records matching some two characters?

On Mon, Aug 31, 2009 at 06:33:08PM -0700, liubin liu scratched on the wall: > > create table and index： > CREATE TABLE data_rt ( id INTEGER, dataid CHAR(4), data CHAR(12), rec_time > INTEGER, data_type CHAR(1) ); > CREATE UNIQUE INDEX i_drt ON data_rt ( id, dataid ); > > there are data in the tab

[sqlite] how to get the records matching some two characters?

create table and index： CREATE TABLE data_rt ( id INTEGER, dataid CHAR(4), data CHAR(12), rec_time INTEGER, data_type CHAR(1) ); CREATE UNIQUE INDEX i_drt ON data_rt ( id, dataid ); there are data in the table of data_rt： sqlite> SELECT * FROM data_rt; 6|1290|7e22473a|857000|22 7|1291|7e22473a|85