Webshop Blog
Reserved Words in the SQL Language
When writing SQL queries and naming columns while building your database, you have to be careful which words you use. Some words are reserved by the SQL language for use as special built in commands and functions. Using these words as a column identifier, for example, will throw an SQL error and your query will die. I have found myself many many times pulling my hair out over a particular query, trying to find out why it isn’t working only to later discover that I named one of my columns with a reserved word. Some of these reserved words include SELECT, UPDATE and WHERE. Those you were probably already familiar with if you have ever written any SQL queries; the full list, however, is actually pretty lengthy and contains many commands you may not have known about. Additionally, as you browse this list, take a moment to look up the commands you aren’t familiar with. This can help you learn about some previously unknown and powerful features of the language.