sqlite

最新推荐文章于 2025-04-27 10:16:01 发布

dddddppppp123

最新推荐文章于 2025-04-27 10:16:01 发布

阅读量541

点赞数 3

文章标签：数据库 sqlite oracle

本文链接：https://blog.youkuaiyun.com/dp__mcu/article/details/147182902

版权

#define SQL_CREATE_TABLE "Create table if not exists User_info(id INTEGER primary key autoincrement, UserName char(20), Password char(20), Level integer NOT NULL)"

#define SQL_INSERT_DATA "Insert into User_info (UserName, Password, Level) values ('%s', '%s', '%d')"

#define SQL_QUERY_DATA "Select * from User_info"

Insert into User_info (UserName, Password, Level) values ('大', 'd', 123)
DELETE FROM User_info WHERE id = 6
SELECT * FROM User_info WHERE id = 1
UPDATE User_info SET Level = 888 WHERE id = 7;