Delete where rowid -> deletes multiple rows

forum.gupta.bugreport (2005-2010)
Mirko
Italy
Posts: 1299
Joined: 04 Apr 2017, 08:56
Location: Geneva

Delete where rowid -> deletes multiple rows

Post by Mirko » 08 Oct 2008, 16:56

 Posted by:  Mirko BONANNO 

Hi folks,

how can a "delete where rowid = " delete more than one row ?

You do not have the required permissions to view the files attached to this post.

RainerE
Germany
Posts: 2204
Joined: 27 Apr 2021, 12:40
Location: Germany

Re: Delete where rowid -> deletes multiple rows

Post by RainerE » 09 Oct 2008, 09:22

 Posted by:  Rainer Ebert 

E.g. if you have a foreign key defined as "on delete cascade", the delete will not only delete the row from salaire but also the rows referencing this row.

Rainer

Mirko
Italy
Posts: 1299
Joined: 04 Apr 2017, 08:56
Location: Geneva

Re: Delete where rowid -> deletes multiple rows

Post by Mirko » 09 Oct 2008, 09:43

 Posted by:  Mirko BONANNO 

Infact you are (fortunately for me) totally right !

Thanks Rainer

Return to “gupta.bugreport”

Who is online

Users browsing this forum: [Ccbot] and 0 guests