Re: DELETE - error_count

2008-10-17 Thread Ian Christian
2008/10/17 Reyna.Sabina <[EMAIL PROTECTED]>: > Hi, > > Running Environment: > MySQL Server version: 5.0.45 > OS is Red-Hat 64-bit > > The table 'junk' doesn't have a row with id=4. Two tests to trap 'errors' > using DELETE follows: > Perhaps I'm missing something - but a delete matching no

DELETE - error_count

2008-10-17 Thread Reyna.Sabina
Hi, Running Environment: MySQL Server version: 5.0.45 OS is Red-Hat 64-bit The table 'junk' doesn't have a row with id=4. Two tests to trap 'errors' using DELETE follows: (1) linux>sqlstmt="USE test; DELETE FROM junk WHERE id =4; SELECT @@error_count;" linux>mysal -e "$sqlstmt" +--