delete where rowid -> deletes multiple rows

forum.gupta.bugreport (2005-2010)
Mirko
Italy
Posts: 983
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 ?

Attachment: delete.bmp

Rainer Ebert

delete where rowid -> deletes multiple rows

Post by Rainer Ebert » 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

Attachment: delete.bmp

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

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

Attachment: delete.bmp

Return to “gupta.bugreport”

Who is online

Users browsing this forum: [Ccbot] and 0 guests