delete where rowid -> deletes multiple rows

forum.gupta.bugreport (2005-2010)
NewsgroupServer
Robot
Robot
Posts: 116488
Joined: 24 Feb 2017, 12:00
Location: World wide

delete where rowid -> deletes multiple rows

Post by NewsgroupServer » 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

NewsgroupServer
Robot
Robot
Posts: 116488
Joined: 24 Feb 2017, 12:00
Location: World wide

delete where rowid -> deletes multiple rows

Post by NewsgroupServer » 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

NewsgroupServer
Robot
Robot
Posts: 116488
Joined: 24 Feb 2017, 12:00
Location: World wide

delete where rowid -> deletes multiple rows

Post by NewsgroupServer » 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