cd showdoc/Sqlite
sqlite3 showdoc.db.php
查看表:
.table
查看建表语句:
.schema user
查看:
select * from user;
增删改查跟mysql区别不大
清空SQLite表后,如何使表的自增ID值也归零。
DELETE FROM 'TableName';
DELETE FROM sqlite_sequence WHERE name='TableName';
简单管理showdoc-sqlite数据库
最新推荐文章于 2022-03-24 11:46:04 发布