在linux系统中,终端操作数据库系统的几个指令:
1.SQLITE3 INFO.DB 打开数据库info.db;
2.CREATE [TEMP] TABLE table_name (column_definitions[, constraints]); 创建表
3.ALTER TABLE table { RENAME TO name | ADD COLUMN column_def };SQLite版的ALTER TABLE命令既可以改变表名,也可以增加字段
4.SELECT * FROM STU 显示所有数据:
5.order by 排序(asc正序, desc逆序)/select * from stu order by id asc/desc
6.where
比较运算符 select * from stu where (not) id > 3
确认范围 select * from stu where id (not) between A and(or) B
字符匹配 select * from stu where name (not) like '__'/'%'
注:_代表一个字符,%代表0个或是多个字符
7. 删除单行数据delete from stu where id = 1
8. 更新数据 update stu set name = 'Jim' where id = 1
9. 删除table drop table stu