Re: delete row with the coloumn having unique key constraint

From: Tony Mountifield <tony_at_mountifield.org>
Date: Thu, 9 Feb 2017 11:56:34 +0000 (UTC)
Message-ID: <o7hldi$eom$1_at_softins.softins.co.uk>

In article <f5116dac-0e67-4778-811d-189899fae671_at_googlegroups.com>, kushal bhattacharya <bhattacharya.kushal4_at_gmail.com> wrote:
> hi,
> Is it possible to delete a row having a cloum with unique key constraint
> without showing any errors as such

Yes, a unique constraint doesn't prevent you from deleting a row; it just prevents you creating a row with a duplicate value in that column (i.e. a value that already exists in that column in another row).

Cheers
Tony

-- 
Tony Mountifield
Work: tony_at_softins.co.uk - http://www.softins.co.uk
Play: tony_at_mountifield.org - http://tony.mountifield.org

Received on Thu Feb 09 2017 - 12:56:34 CET

This message: [ Message body ]
Next message: Jivanmukta: "cannot connect from mysql client nor PHP, only sudo"
In reply to kushal bhattacharya: "delete row with the coloumn having unique key constraint"
Next in thread: kushal bhattacharya: "Re: delete row with the coloumn having unique key constraint"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message