Re: [sqlite] To BEGIN or not to BEGIN. That is the question...

2013-08-29 Thread Doug Nebeker
-Original Message- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Igor Tandetnik Sent: Wednesday, August 28, 2013 5:44 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] To BEGIN or not to BEGIN. That is the question... On 8/28/2013 6:28 PM, jose

Re: [sqlite] To BEGIN or not to BEGIN. That is the question...

2013-08-28 Thread Igor Tandetnik
On 8/28/2013 6:28 PM, jose isaias cabrera wrote: I know that if I am doing INSERTs and such, I need to, BEGIN; INSERT... END; No, you don't need to. You can, if you want to, but there's no reason to have to. But, do I need to begin if I am going to create a table? ie. BEGIN; CRE

[sqlite] To BEGIN or not to BEGIN. That is the question...

2013-08-28 Thread jose isaias cabrera
Greetings. I know that if I am doing INSERTs and such, I need to, BEGIN; INSERT... END; But, do I need to begin if I am going to create a table? ie. BEGIN; CREATE TABLE tableName ( JobID integer primary key, SubProjID integer, ProjID integer ); END; Also, what other co