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"
+---------------+
| @@error_count |
+---------------+
| 0 |
+---------------+
(2) linux>mysql
mysql> DELETE FROM junk WHERE id=4;
Query OK, 0 rows affected (0.00 sec)
mysql> SELECT @@error_count;
+-----------------------+
| @@session.error_count |
+-----------------------+
| 0 |
+-----------------------+
1 row in set (0.00 sec)
Is it OK that the result of 'SELECT @@error_count;' is '0' instead of '1'?
Any clues?
Thanks!
Reyna
_________________________________________________________
Reyna Sabina Phone: (305) 361-4324
NOAA/AOML/PHOD Fax: (305) 361-4392
4301 Rickenbacker Causeway Email: [EMAIL PROTECTED]
Miami, FL 33149-1087
"Things do not get better by being left alone."
-Winston Churchill
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
