部分常用到的SQLite语句

最新推荐文章于 2024-07-27 16:46:43 发布

原创最新推荐文章于 2024-07-27 16:46:43 发布 · 844 阅读

CC 4.0 BY-SA版权

250 篇文章

订阅专栏

本文详细介绍了一系列SQL操作案例，包括创建新表、从已有表中选取字段生成新表、按特定顺序排序并插入数据等。通过具体步骤展示了如何利用SQL语言高效地管理数据库表结构和数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

drop table if exists learning_new4;

create table learning_new4(id INTEGER default 1 primary key AUTOINCREMENT, sTtile text , sContent text, sort text);

insert into learning_new4(sTtile, sContent, sort) select sTtile, sContent, sort from learning_new3 order by sort desc;

// 从这个表中选取一部分字段，然后放到一个新生成的表中

drop table if exists FullNew;

create table FullNew(id INTEGER DEFAULT 1 PRIMARY KEY AUTOINCREMENT, sTitle varchar(80) , sContent memo, sort TEXT);

insert into FullNew(sTitle, sContent, sort) select field2, field3, field4 from learning_new4 order by field4 desc;

// 创建新表从已有表中。

drop table if exists duanxinleyuan;

create table duanxinleyuan(id INTEGER DEFAULT 1 PRIMARY KEY AUTOINCREMENT, sTitle varchar(80) , sContent memo);

insert into duanxinleyuan(sTitle, sContent) select sTitle, sContent from FullNew where id between 1 and 59;

// 把FullNew中的id为60到140之间的行插入到已有表的末尾

insert into duanxinleyuan(sTitle, sContent) select sTitle, sContent from FullNew where id between 60 and 140;

// 如我想删除表A中ID=50~150之间的100条记录

// 删除行数据

DELETE FROM A WHERE chapterid > 49 AND chapterid < 151

// 从已有表中进行倒序，生成新表，按id倒序

drop table if exists guihua_des;

create table guihua_des(id INTEGER default 1 primary key AUTOINCREMENT, sTitle varchar(80) , sContent memo);

insert into guihua_des(sTitle, sContent) select sTitle, sContent from guihua order by id desc;