Details

      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.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              nick.denning@diegesis.co.uk Nicholas Denning
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated: