Maybe you didn't see an error in the first case because whatever happened
was treated as a warning.
did you try:
SHOW WARNINGS;
This will show you the warnings associated with the last statement executed
(MySQL 4.10 and above).
-----Original Message-----
From: Jorge Bastos [mailto:mysq...@decimal.pt]
Sent: Sunday, November 21, 2004 5:26 PM
To: dot...@lists.mysql.com
Subject: get error
Reggie or mailling list,
I have a question, is it possible to retrieve the error number from mysql,
for example like this:
mysql> create table xx (i int(1));
Query OK, 0 rows affected (0.16 sec)
mysql> create table xx (i int(1));
ERROR 1050: Table 'xx' already exists
For the table exists i have the error number 1050.
Can i get that number some how?