sqlite:
1. create table test4(uid int,name varchar(20));
2. insert into test4 values(1,'XXXXXXX');
................................
insert into test4 values(39,'XXXXXXX');
3. delete from test4 where uid=1;
................................
delete from test4 where uid=29;
Windows 7: Force Eject: All DMLs be sucessfully done.
Fedora 10: Force unmount: No such table !!!
Don't Empry Trash : All DMLs be sucessfully done.
ML:
1. set autocommit on;
2. and run the same commands as above,
Windows 7: N/A
Fedora 10: Force unmount: Test1: Create,insert complete; deletion were not done !!
Test2: MemoryMgr initialize ERROR (-163) Error: DB File read fail !!!!!
Don't Empry Trash : A ll DMLs be sucessfully done.
原文链接:https://www.f2er.com/sqlite/203081.html