Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Transaction support #50

Closed
nhoening opened this issue Mar 28, 2013 · 2 comments
Closed

Transaction support #50

nhoening opened this issue Mar 28, 2013 · 2 comments

Comments

@nhoening
Copy link
Owner

If one INSERT statement fails for some reason, the previously imported ones should be rolled back. Very useful.

I'm not sure if Postgres and MySQL use the same syntax and since which versions they support it. Expert advice appreciated.

@disconn3ct
Copy link

https://dev.mysql.com/doc/refman/5.0/en/commit.html

They both can use "begin;" and "commit;".

@nhoening
Copy link
Owner Author

Thanks.

As for versions, it seems transactions in MySQL came with InnoDB, with an acquisition made in 2005 only: In October 2005, Oracle Corporation acquired Innobase OY, the Finnish company that developed the third-party InnoDB storage engine that allows MySQL to provide such functionality as transactions and foreign keys..MySQL 5.0 seems to be stable since 2009, so we can assume everyone has that, I think.

In postgres, I see transaction support back in 8.3 which is also old, from 2008.

Btw, both documentations seem to prefer capital letters. Do both work? Anyway, I'll use capital letters.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants