From the course: Learning SQL Programming

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Overcoming common SQL mistakes

Overcoming common SQL mistakes - SQL Tutorial

From the course: Learning SQL Programming

Start my 1-month free trial

Overcoming common SQL mistakes

“

- [Instructor] When working with SQL, there are a few common mistakes that it's easy to make. SQL is not a very forgiving language if you don't have the syntax just right. And the errors that you'll get back from the database software if you miss type something can be cryptic at best. So if you're getting an error message, be sure to read it carefully and see if it points you in the right direction. If you have a syntax error that you just can't find, start breaking down the statement into pieces that do work, and then put the statement together again, keeping an eye on when an error happens. It's easy to mix up parentheses or misspell a field name. And when you're learning, it can be tricky to remember the order of clauses or whether a keyword is missing an important part. Keep in mind that if you're using a text string, you need to put it in single quotes for it to be treated as text. And if for some reason your database has spaces in field names, which is allowed, but isn't really…

Contents