I have two SQLite database query INSERT into UserAccessLevels VALUES (12,"a", 21, "bb", 21) and INSERT INTO UserPersonalInfo VALUES (17, "a","a1",2,"a2","a3") two of them are working fine separately. I am tying to combine two of them together is it possible to do for SQL Database.
2 Answers
BEGIN
INSERT INTO UserAccessLevels VALUES (12,"a", 21, "bb", 21)
INSERT INTO UserPersonalInfo VALUES (17, "a","a1",2,"a2","a3")
END
2 Comments
raz
I am getting
SQLiteManager: Likely SQL syntax error: BEGIN INSERT INTO UserAccessLevels VALUES (12,"a", 21, "bb", 21) INSERT INTO UserPersonalInfo VALUES (17, "a","a1",2,"a2","a3") END [ near "INSERT": syntax error ]
Vincent Savard
Try to explain what your query is supposed to do.
Short answer: use a transaction to make sure both inserts happen as an atomic unit (the entire transaction will either succeed completely or fail completely).
If you are using SQLite, an example transaction would look something like this:
BEGIN;
INSERT INTO UserAccessLevels VALUES (12,"a", 21, "bb", 21);
INSERT INTO UserPersonalInfo VALUES (17, "a","a1",2,"a2","a3");
COMMIT;
If you are submitting a single string of all this for execution, the semicolons are critical.
If you don't actually need a transaction, or if there is one already created for you (by SQLiteManager, etc.), then simply run the INSERT statements with semicolons after each one, and you can exclude the BEGIN and COMMIT statements.
3 Comments
raz
I am getting
SQLiteManager: BEGIN; [ cannot start a transaction within a transaction ] error..........
SlimsGhost
Is SQLiteManager its own application with its own GUI? It seems to be wrapping everything in a transaction already, so trying to start another one won't work. Have you tried just running the two INSERT statements with semicolons at the end of each one? If that works, I'll update my answer to remove the transaction stuff.
raz
I found the solution in stackoverflow.com/questions/12741891/….. it was already available. I think next time I have to pay more attention for google search. ;)
;is used to delimter queriesINSERTusually only works on one table, although some databases do have methods for combining them into a single query.