创建/打开一个数据库:
sqlite3 mysq.sqlite
//mysq.sqlite 为数据库名 如果已存在就代开 不存在就创建
创建一个表:
creat table myinfo(age intenger,name text);
//myinfo是表名 后面是参数和类型
插入一条数据:
insert into myinfo (age,name)values(22,kluermn);
删除一条数据:
delete from myinfo where name = 'kluermn';
查找数据:
select * from myinfo;
修改表数据:
update myinfo set name = 'mn' where age = 22;
连表查询:
select * from myinfo left join youinfo on myinfo.name = youinfo.name;