建设表
CREATE TABLE arg_info(no TEXT,name TEXT,energy REAL,protein REAL);
增加
INSERT INTO arg_info(no,name,energy,protein) VALUES (‘001′,’芝麻’,10,1);
INSERT INTO arg_info(no,name,energy,protein) VALUES (‘002′,’玉米’,11,2);
INSERT INTO arg_info(no,name,energy,protein) VALUES (‘003′,’大豆’,12,3);
INSERT INTO arg_info(no,name,energy,protein) VALUES (‘004′,’花生’,13,4);
删除
DELETE FROM arg_info WHERE no=’004′;
修改
UPDATE arg_info SET energy=37.5 WHERE no=’002′;
查询
SELECT * FROM arg_info;
升序
SELECT * FROM arg_info ORDER by energy ASC;
降序
SELECT * FROM arg_info ORDER by energy DESC;
条件查询
SELECT * FROM arg_info WHERE protein
Original: https://blog.csdn.net/weixin_52346212/article/details/122097578
Author: xxwddzz
Title: 2021-12-10 sqlite数据库 sqlite表
原创文章受到原创版权保护。转载请注明出处:https://www.johngo689.com/817426/
转载文章受原作者版权保护。转载请注明原作者出处!