这个屌丝很懒，什么也没留下！

sqlite3基本操作_sqlte3操作

作者：IT小白 | 2024-04-26 12:00:27

1.进入sqlite3


sqlite3
sqlite3 student //将数据库保存成文件

.exit


create table student(id integer, name text, age integer);
create table if not exists student(id integer, name text, age integer);

.schema


insert into student (id, name, age) values(1, "jack", 18);
insert into student values (2, "cooper", 19),(3, "xiaoming", 16);

select * from student;

update student set age = 10 where id = 1;

drop table student;

声明：本文内容由网友自发贡献，转载请注明出处：【wpsshop】