On 7 Jul 2009, at 3:06pm, Alberto Daniotti wrote:
> Thank you for the answer.
> Could you give me an example of use of BEGIN TRANSACTION?
BEGIN TRANSACTION;
INSERT INTO favouriteColour (person,colour) VALUES ('Jenny', 'orange');
INSERT INTO favouriteColour (person) VALUES ('John');
INSERT INTO favouriteColour (person,colour) VALUES ('Fred', 'blue');
INSERT INTO bestTrinket (colour,trinketName) VALUES ('white', 'hat');
INSERT INTO bestTrinket (colour,trinketName) VALUES ('blue',
'umbrella');
COMMIT TRANSACTION;
See <http://www.sqlite.org/lang_transaction.html> for the reason why.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
