5 messages in com.mysql.lists.dotnetRE: get error
FromSent OnAttachments
Jorge Bastos21 Nov 2004 14:25 
Patrick Questembert21 Nov 2004 14:31 
Jorge Bastos22 Nov 2004 01:59 
Jorge Bastos22 Nov 2004 02:05 
Jorge Bastos22 Nov 2004 03:05 
Subject:RE: get error
From:Patrick Questembert (patr@nyc.rr.com)
Date:11/21/2004 02:31:54 PM
List:com.mysql.lists.dotnet

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?