Re: [sqlite] SQL error: near "READ_ONLY": syntax error
Look here - http://www.sqlite.org/lang_transaction.html LuYanJun wrote: > Thanks, But I step the instruction fellow the hint by offcial document by > which said that's correct(BTW forgive me my poor english ): > http://www.sqlite.org/concurrency.html > 4.1 Read-only transactions > BEGIN READ_ONLY; > SELECT * FROM t1; > SELECT * FROM t2; > COMMIT; > > 4.2 Defer write locks > BEGIN READ_INITIALLY; > SELECT * FROM t1; > SELECT * FROM t2; > COMMIT; > 4.4 Defer writes > BEGIN DEFER_WRITES; > SELECT * FROM t1; > -- Processing delay > UPDATE t1 SET ... WHERE ... > SELECT * FROM t2; > -- Processing delay > UPDATE t2 SET ... WHERE ... > SELECT * FROM t3; > -- Processing delay > UPDATE t3 SET ... WHERE ... > COMMIT; > ...and so forth. > > I wonder that does do something with version? > - Original Message - > From: "Marten Feldtmann" <[EMAIL PROTECTED]> > To: <sqlite-users@sqlite.org> > Sent: Monday, December 18, 2006 3:00 PM > Subject: Re: [sqlite] SQL error: near "READ_ONLY": syntax error > > > >>LuYanJun schrieb: >> >>>Hi guy: >>>what does the follow meaning? >>>sqlite> BEGIN READ_ONLY; >>>SQL error: near "READ_ONLY": syntax error >> >>READ_ONLY is not a valid option for this command. >> >>BEGIN [DEFERRED | EXCLUSIVE | IMMEDIATE] >> >>Marten >> >>- >>To unsubscribe, send email to [EMAIL PROTECTED] >>- >> > >> - To unsubscribe, send email to [EMAIL PROTECTED] -
Re: [sqlite] SQL error: near "READ_ONLY": syntax error
Thanks, But I step the instruction fellow the hint by offcial document by which said that's correct(BTW forgive me my poor english ): http://www.sqlite.org/concurrency.html 4.1 Read-only transactions BEGIN READ_ONLY; SELECT * FROM t1; SELECT * FROM t2; COMMIT; 4.2 Defer write locks BEGIN READ_INITIALLY; SELECT * FROM t1; SELECT * FROM t2; COMMIT; 4.4 Defer writes BEGIN DEFER_WRITES; SELECT * FROM t1; -- Processing delay UPDATE t1 SET ... WHERE ... SELECT * FROM t2; -- Processing delay UPDATE t2 SET ... WHERE ... SELECT * FROM t3; -- Processing delay UPDATE t3 SET ... WHERE ... COMMIT; ...and so forth. I wonder that does do something with version? - Original Message - From: "Marten Feldtmann" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> Sent: Monday, December 18, 2006 3:00 PM Subject: Re: [sqlite] SQL error: near "READ_ONLY": syntax error > LuYanJun schrieb: >> Hi guy: >> what does the follow meaning? >> sqlite> BEGIN READ_ONLY; >> SQL error: near "READ_ONLY": syntax error > READ_ONLY is not a valid option for this command. > > BEGIN [DEFERRED | EXCLUSIVE | IMMEDIATE] > > Marten > > - > To unsubscribe, send email to [EMAIL PROTECTED] > - > >
Re: [sqlite] SQL error: near "READ_ONLY": syntax error
LuYanJun schrieb: > Hi guy: > what does the follow meaning? > sqlite> BEGIN READ_ONLY; > SQL error: near "READ_ONLY": syntax error READ_ONLY is not a valid option for this command. BEGIN [DEFERRED | EXCLUSIVE | IMMEDIATE] Marten - To unsubscribe, send email to [EMAIL PROTECTED] -
