Syntax Error

Syntax Errors are like common mistakes that happen a lot in the developer's world. I'm pretty sure every developer, no matter how experienced, must have come across this error before. Once in my experience in New Zealand, a so-called Senior Architects spent three days, trying to fix a syntax error. Later he told the senior management that they found a problem in the business logic, making it sound like a big achievement. I am sure, if my that time Management and team is reading this topic, they will remember and must be smiling now lolz 😊. But just so you know, syntax errors are really just about how skilled a developer is and not about problems in the business stuff.

A syntax error is a type of error that occurs when the code you write does not conform to the syntax rules of the programming language. Syntax errors prevent the interpreter or compiler from translating your code into machine-readable instructions, and as a result, the program cannot be executed until the syntax errors are corrected.

Syntax errors can come in all the languages, for example let’s explore it in SQL Commands. In SQL, syntax errors often occur when there are issues with the structure of SQL statements. Here are a few examples of SQL syntax errors:

1. Missing Semicolon:

-- Example 1

SELECT * FROM employees.

WHERE department = 'IT'

-- Syntax Error: Missing semicolon at the end of the statement

-- Syntax Error: Missing closing parenthesis in the WHERE clause

2. Missing Quotes for String Literal:

-- Example 2

INSERT INTO customers (customer_id, customer_name, city)

VALUES (101, 'John Doe, 'New York');

-- Syntax Error: Missing closing quote for the 'customer_name' value

3. Incorrect JOIN Syntax:

-- Example 3

SELECT employees.employee_id, departments.department_name

FROM employees

JOIN departments

ON employees.department_id = departments.department_id

WHERE salary > 50000;

-- Syntax Error: Incorrect JOIN syntax, it should be INNER JOIN or LEFT JOIN, etc.

4. Missing FROM Clause:

-- Example 4

SELECT employee_id, employee_name

WHERE department = 'Sales';

-- Syntax Error: Missing FROM clause in the SELECT statement

In these examples, SQL syntax errors involve missing or incorrect elements such as semicolons, quotes, or proper usage of keywords. Identifying and correcting these errors is essential for the successful execution of SQL queries or commands. SQL development environments and database systems typically highlight or report syntax errors during the parsing phase, making it easier for developers to identify and fix issues.