Error code: 1109 Unknown table & #39; ename & #39; in multi delete, 1109 ename

Error code: 1109 Unknown table 'ename' in multi delete, 1109 ename

1. Error description

1 queries executed, 0 success, 1 errors, 0 warnings query: delete. ename from emp error code: 1109 Unknown table 'ename 'in multi delete execution time: 0 sec Transfer Time: 0 sec total time consumed: 0 sec

2. Error cause

Delete records in database tables and directly Delete Fields

DELETE a. ename FROM emp;

This does not conform to the SQL statement syntax.

3. Solution

To delete a record in a database table, you must delete it according to the specific conditions.

Delete from emp a WHERE a. ename = 'Research Department ';

Copyright Disclaimer: This article is an original article by the blogger and cannot be reproduced without the permission of the blogger.