Problem with using dot notation in SQLite

Viewed 33

How is dot notation (.) used in SQL?

Why is the query below giving an error?

update Employee2
set Employee2.department = 'Marketing'
where Employee2.e_id=2;

Employee2 table:

enter image description here

Error:

[SQLITE_ERROR] SQL error or missing database (near ".": syntax error)

Employee2.department is probably causing the problem but not Employee2.e_id although both are dot notations.

0 Answers
Related