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;

声明：本网页内容为用户发布，旨在传播知识，不代表本网认同其观点，若有侵权等问题请及时与本网联系，我们将在第一时间删除处理。E-MAIL:11247931@qq.com