Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
-
None
-
None
Description
In almost all circumstances you can use a correlation name as a short cut to a table name for example MT in the following query
SELECT MT.* |
FROM MYTABLE MT |
WHERE MT.MYKEY = 5; |
However it looks like you cannot use a correlation name on a delete statement in mariadb so the following generates an error.
DELETE FROM MYTABLE MT |
WHERE MT.KEY = 5; |
You can use a correlation name in this manner in most other databases.
This is not that big an issue, but an irritation.