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
203,137 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.

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 :)

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

Tommy Gebru
Tommy Gebru
30,148 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: