[sqlite] Re: How to know which rows are affected by UPDATE/DELETE?

[Igor Tandetnik]

Gilles Ganault <gilles.ganault-jG/[EMAIL PROTECTED]>
wrote: 
Is there a way to know which rows will be changed by a query like
this? 

UPDATE suppliers SET name = 'HP' WHERE name = 'IBM';

Sure:

select rowid from suppliers where name='IBM';

Igor Tandetnik

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------