以表test7 为例
创建一张表:
create table test7(id int,addr char,name varchar(20));
插入一行数据:
insert into test7 values(011,'beijing','lidongwei');
增加表的列:
alter table test7 add a4float;
alter table test7 add a5 REAL;
查看每行rowid:
select rowid from test7;
根据rowid查看数据:
select * from test7 where rowid='AAAU83AAEAAAa52AAA';
更新数据:
update test7 set id=002,addr='haidian',name='xizhimen';
删除数据:
delete from test7 where id=002;
删除整张表数据:
truncate table test7;