Databases Modifying Data with SQL Handling Errors When Manipulating Data Rolling Back from Transactions

oliverchou
oliverchou
20,886 Points

Am I getting this right?

"begin", "commit".... Can I simplify this to "edit," and "save"? and "auto commit" as "auto save"?

3 Answers

Steven Parker
Steven Parker
182,270 Points

Like most computer languages, SQL has specific keywords that it recognizes. You cannot substitute other words, even if they have similar (or identical) meanings in English.

Tommy Gebru
Tommy Gebru
29,805 Points

Hey Oliverchou, keep in mind that, the challenges are being tested for specific answers and if in the right direction can provide some really useful hints or error messages to keep you on track!

Also be sure to use the SQL playground in each lesson module - its a great way to see live responses and practice the content :sunglasses:

oliverchou
oliverchou
20,886 Points

Thank you guys I was just making sure if my comprehension was correct, which is merely a note to myself to help me get the concept.

I understand I still have to use the right and acceptable keyword though.

Thanks, anyway :)

Steven Parker
Steven Parker
182,270 Points

oliverchou — Glad to help. You can mark a question solved by choosing a "best answer".
And happy coding!

professionalb
professionalb
Full Stack JavaScript Techdegree Student 5,082 Points

haha this Q & A thread is a good lesson in communication ;)

oliverchou I understood what you were saying immediately, but keep in mind, computers and often times programmers take everything you say literally