sqlite3 integer字段怎么排序
发布网友
发布时间：2024-10-24 02:22
共1个回答
热心网友
时间：2024-10-26 10:30
$ sqlite3
SQLite version 3.7.13 2012-06-11 02:05:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> create table tb_tmp (id int);
sqlite> insert into tb_tmp values (1);
sqlite> insert into tb_tmp values (2);
sqlite> insert into tb_tmp values (3);
sqlite> insert into tb_tmp values (4);
sqlite> insert into tb_tmp values (5);
sqlite> insert into tb_tmp values (6);
sqlite> insert into tb_tmp values (7);
sqlite> insert into tb_tmp values (8);
sqlite> insert into tb_tmp values (9);
sqlite> insert into tb_tmp values (10);
sqlite> insert into tb_tmp values (11);
sqlite> select * from tb_tmp;
