Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-5751

INSERT ... ON DUPLICATE KEY IGNORE

    XMLWordPrintable

Details

    • Task
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • None
    • None
    • None

    Description

      I would like to request the following feature:

      INSERT ... ON DUPLICATE KEY IGNORE

      This feature is to address the issue posted here of having to perform a null operation:
      http://stackoverflow.com/questions/1361340/how-to-insert-if-not-exists-in-mysql

      It would work much like INSERT IGNORE except that it would only ignore duplicate key errors, but support all other error types. This is contrary to INSERT IGNORE as it reports all other errors as warnings, according to the manual.

      Attachments

        Activity

          People

            Unassigned Unassigned
            belugabehr BELUGABEHR
            Votes:
            4 Vote for this issue
            Watchers:
            6 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.