| List: | Commits | « Previous MessageNext Message » | |
| From: | paul.dubois | Date: | October 6 2008 6:49pm |
| Subject: | svn commit - mysqldoc@docsrva: r11997 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-6.0 | ||
| View as plain text | |||
Author: paul Date: 2008-10-06 18:49:24 +0200 (Mon, 06 Oct 2008) New Revision: 11997 Log: r34560@frost: paul | 2008-10-06 11:50:19 -0500 New section on types of error values Describe SQLSTATE classes Modified: trunk/refman-4.1/errors-problems.xml trunk/refman-5.0/errors-problems.xml trunk/refman-5.1/errors-problems-core.xml trunk/refman-6.0/errors-problems.xml Property changes on: trunk ___________________________________________________________________ Name: svk:merge - 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:34558 b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:33554 + 4767c598-dc10-0410-bea0-d01b485662eb:/mysqldoc-local/mysqldoc/trunk:35828 7d8d2c4e-af1d-0410-ab9f-b038ce55645b:/mysqldoc-local/mysqldoc:34560 b5ec3a16-e900-0410-9ad2-d183a3acac99:/mysqldoc-local/mysqldoc/trunk:14218 bf112a9c-6c03-0410-a055-ad865cd57414:/mysqldoc-local/mysqldoc/trunk:33554 Modified: trunk/refman-4.1/errors-problems.xml =================================================================== --- trunk/refman-4.1/errors-problems.xml 2008-10-06 16:43:58 UTC (rev 11996) +++ trunk/refman-4.1/errors-problems.xml 2008-10-06 16:49:24 UTC (rev 11997) Changed blocks: 2, Lines Added: 71, Lines Deleted: 3; 2510 bytes @@ -5964,6 +5964,75 @@ </section> + <section id="error-types"> + + <title>Types of Error Values</title> + + <para> + When an error occurs in MySQL, the server returns two types of + error values: + </para> + + <itemizedlist> + + <listitem> + <para> + A MySQL-specific error code. This value is numeric. It is not + portable to other database systems. MySQL error codes are + returned by the <function role="capi">mysql_errno()</function> + function. + </para> + </listitem> + + <listitem> + <para> + An SQLSTATE value. The value is a five-character string (for + example, <literal>'42S02'</literal>). The values are specified + by ANSI SQL and ODBC and are more standardized. SQLSTATE + values are returned by the + <function role="capi">mysql_sqlstate()</function> function. + </para> + </listitem> + + </itemizedlist> + + <para> + The first two characters of an SQLSTATE value is the error class: + </para> + + <itemizedlist> + + <listitem> + <para> + <literal>'00'</literal> indicates success. + </para> + </listitem> + + <listitem> + <para> + <literal>'01'</literal> indicates a warning. + </para> + </listitem> + + <listitem> + <para> + <literal>'02'</literal> indicates <quote>not found.</quote> + These values are relevant only within the context of cursors + and are used to control what happens when a cursor reaches the + end of a data set. + </para> + </listitem> + + <listitem> + <para> + Other values indicate an exception. + </para> + </listitem> + + </itemizedlist> + + </section> + <section id="error-messages-server"> <title>Server Error Codes and Messages</title> @@ -5988,9 +6057,8 @@ <listitem> <para> - A numeric error value (<literal>1146</literal>). This number - is MySQL-specific and is not portable to other database - systems. + A numeric error code (<literal>1146</literal>). This number is + MySQL-specific and is not portable to other database systems. </para> </listitem> Modified: trunk/refman-5.0/errors-problems.xml =================================================================== --- trunk/refman-5.0/errors-problems.xml 2008-10-06 16:43:58 UTC (rev 11996) +++ trunk/refman-5.0/errors-problems.xml 2008-10-06 16:49:24 UTC (rev 11997) Changed blocks: 2, Lines Added: 71, Lines Deleted: 3; 2510 bytes @@ -5690,6 +5690,75 @@ </section> + <section id="error-types"> + + <title>Types of Error Values</title> + + <para> + When an error occurs in MySQL, the server returns two types of + error values: + </para> + + <itemizedlist> + + <listitem> + <para> + A MySQL-specific error code. This value is numeric. It is not + portable to other database systems. MySQL error codes are + returned by the <function role="capi">mysql_errno()</function> + function. + </para> + </listitem> + + <listitem> + <para> + An SQLSTATE value. The value is a five-character string (for + example, <literal>'42S02'</literal>). The values are specified + by ANSI SQL and ODBC and are more standardized. SQLSTATE + values are returned by the + <function role="capi">mysql_sqlstate()</function> function. + </para> + </listitem> + + </itemizedlist> + + <para> + The first two characters of an SQLSTATE value is the error class: + </para> + + <itemizedlist> + + <listitem> + <para> + <literal>'00'</literal> indicates success. + </para> + </listitem> + + <listitem> + <para> + <literal>'01'</literal> indicates a warning. + </para> + </listitem> + + <listitem> + <para> + <literal>'02'</literal> indicates <quote>not found.</quote> + These values are relevant only within the context of cursors + and are used to control what happens when a cursor reaches the + end of a data set. + </para> + </listitem> + + <listitem> + <para> + Other values indicate an exception. + </para> + </listitem> + + </itemizedlist> + + </section> + <section id="error-messages-server"> <title>Server Error Codes and Messages</title> @@ -5714,9 +5783,8 @@ <listitem> <para> - A numeric error value (<literal>1146</literal>). This number - is MySQL-specific and is not portable to other database - systems. + A numeric error code (<literal>1146</literal>). This number is + MySQL-specific and is not portable to other database systems. </para> </listitem> Modified: trunk/refman-5.1/errors-problems-core.xml =================================================================== --- trunk/refman-5.1/errors-problems-core.xml 2008-10-06 16:43:58 UTC (rev 11996) +++ trunk/refman-5.1/errors-problems-core.xml 2008-10-06 16:49:24 UTC (rev 11997) Changed blocks: 2, Lines Added: 71, Lines Deleted: 3; 2525 bytes @@ -5574,6 +5574,75 @@ </section> + <section id="error-types"> + + <title>Types of Error Values</title> + + <para> + When an error occurs in MySQL, the server returns two types of + error values: + </para> + + <itemizedlist> + + <listitem> + <para> + A MySQL-specific error code. This value is numeric. It is not + portable to other database systems. MySQL error codes are + returned by the <function role="capi">mysql_errno()</function> + function. + </para> + </listitem> + + <listitem> + <para> + An SQLSTATE value. The value is a five-character string (for + example, <literal>'42S02'</literal>). The values are specified + by ANSI SQL and ODBC and are more standardized. SQLSTATE + values are returned by the + <function role="capi">mysql_sqlstate()</function> function. + </para> + </listitem> + + </itemizedlist> + + <para> + The first two characters of an SQLSTATE value is the error class: + </para> + + <itemizedlist> + + <listitem> + <para> + <literal>'00'</literal> indicates success. + </para> + </listitem> + + <listitem> + <para> + <literal>'01'</literal> indicates a warning. + </para> + </listitem> + + <listitem> + <para> + <literal>'02'</literal> indicates <quote>not found.</quote> + These values are relevant only within the context of cursors + and are used to control what happens when a cursor reaches the + end of a data set. + </para> + </listitem> + + <listitem> + <para> + Other values indicate an exception. + </para> + </listitem> + + </itemizedlist> + + </section> + <section id="error-messages-server"> <title>Server Error Codes and Messages</title> @@ -5598,9 +5667,8 @@ <listitem> <para> - A numeric error value (<literal>1146</literal>). This number - is MySQL-specific and is not portable to other database - systems. + A numeric error code (<literal>1146</literal>). This number is + MySQL-specific and is not portable to other database systems. </para> </listitem> Modified: trunk/refman-6.0/errors-problems.xml =================================================================== --- trunk/refman-6.0/errors-problems.xml 2008-10-06 16:43:58 UTC (rev 11996) +++ trunk/refman-6.0/errors-problems.xml 2008-10-06 16:49:24 UTC (rev 11997) Changed blocks: 2, Lines Added: 71, Lines Deleted: 3; 2510 bytes @@ -5547,6 +5547,75 @@ </section> + <section id="error-types"> + + <title>Types of Error Values</title> + + <para> + When an error occurs in MySQL, the server returns two types of + error values: + </para> + + <itemizedlist> + + <listitem> + <para> + A MySQL-specific error code. This value is numeric. It is not + portable to other database systems. MySQL error codes are + returned by the <function role="capi">mysql_errno()</function> + function. + </para> + </listitem> + + <listitem> + <para> + An SQLSTATE value. The value is a five-character string (for + example, <literal>'42S02'</literal>). The values are specified + by ANSI SQL and ODBC and are more standardized. SQLSTATE + values are returned by the + <function role="capi">mysql_sqlstate()</function> function. + </para> + </listitem> + + </itemizedlist> + + <para> + The first two characters of an SQLSTATE value is the error class: + </para> + + <itemizedlist> + + <listitem> + <para> + <literal>'00'</literal> indicates success. + </para> + </listitem> + + <listitem> + <para> + <literal>'01'</literal> indicates a warning. + </para> + </listitem> + + <listitem> + <para> + <literal>'02'</literal> indicates <quote>not found.</quote> + These values are relevant only within the context of cursors + and are used to control what happens when a cursor reaches the + end of a data set. + </para> + </listitem> + + <listitem> + <para> + Other values indicate an exception. + </para> + </listitem> + + </itemizedlist> + + </section> + <section id="error-messages-server"> <title>Server Error Codes and Messages</title> @@ -5571,9 +5640,8 @@ <listitem> <para> - A numeric error value (<literal>1146</literal>). This number - is MySQL-specific and is not portable to other database - systems. + A numeric error code (<literal>1146</literal>). This number is + MySQL-specific and is not portable to other database systems. </para> </listitem>
| Thread | ||
|---|---|---|
| • svn commit - mysqldoc@docsrva: r11997 - in trunk: . refman-4.1 refman-5.0 refman-5.1 refman-6.0 | paul.dubois | 6 Oct |
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Page generated in 0.516 sec. using MySQL 5.1.14-beta-log