On 24 Jul 2015, at 9:05am, Jan Leimbach <jan.leimbach at gmail.com> wrote:
> I created a simple test statement like UPDATE tablename SET field = '123'
> WHERE field = '321'
> It returns always "Not an error" and does not update the table.
It's like your Mum told you to finish empty all bins but they were already
empty. Then she asks you if you did it and you say "Yes". You did what she
asked you.
The command will change data in all rows where this is true:
WHERE field = '321'
If there is one row where field = '321', it will change one row and report "Not
an error".
If there are six rows where field = '321', it will change six rows and report
"Not an error".
If there are no rows where field = '321', it will change no rows and report
"Not an error". Because it did its job. There just wasn't anything to do.
So if it apparently doesn't do anything try executing this command
SELECT * FROM tablename WHERE field = '321'
and see if there was anything to do.
Simon.
