svn commit - mysqldoc@docsrva: r3286 - trunk/refman-5.0

[paul]

Author: paul
Date: 2006-09-07 18:48:19 +0200 (Thu, 07 Sep 2006)
New Revision: 3286

Log:
mysql_errno(): Add text that got added to 4.1/5.1, but not
5.0 for some reason.


Modified:
   trunk/refman-5.0/apis.xml


Modified: trunk/refman-5.0/apis.xml
===================================================================
--- trunk/refman-5.0/apis.xml	2006-09-07 16:14:41 UTC (rev 3285)
+++ trunk/refman-5.0/apis.xml	2006-09-07 16:48:19 UTC (rev 3286)
Changed blocks: 1, Lines Added: 16, Lines Deleted: 0; 1052 bytes

@@ -2524,6 +2524,22 @@
         </para>
 
         <para>
+          MySQL-specific error numbers returned by
+          <literal>mysql_errno()</literal> differ from SQLSTATE values
+          returned by <literal>mysql_sqlstate()</literal>. For example,
+          the <command>mysql</command> client program displays errors
+          using the following format, where <literal>1146</literal> is
+          the <literal>mysql_errno()</literal> value and
+          <literal>'42S02'</literal> is the corresponding
+          <literal>mysql_sqlstate()</literal> value:
+        </para>
+
+<programlisting>
+shell&gt; <userinput>SELECT * FROM no_such_table;</userinput>
+ERROR 1146 (42S02): Table 'test.no_such_table' doesn't exist
+</programlisting>
+
+        <para>
           <emphasis role="bold">Return Values</emphasis>
         </para>