SQL-92定义的errorcode 通过PDO什么的返回的值~

from： http://docstore.mik.ua/orelly/java-ent/jenut/ch08_06.htm

就平常我们经常遇到的返回码比如42000

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

可以看到是大分类42 Syntax error or access rule violation 子分类无

如果需要根据errorcode进行捕获，那么。。。就参考下面这张表就ok了

The SQL-92 standard defines a set of SQLSTATE return codes. SQLSTATE is defined as a five-character string, where the leftmost two characters define the error class, and the remaining three characters define the error subclass. Some database vendors may extend these return codes; classes beginning with the numbers 5 through 9 and letters I through Z are reserved for such implementation-specific extensions. The SQLSTATE code for a particular JDBC action can be retrieved via the getSQLState() method of SQLException. Table 8-3 lists the SQLSTATE return codes defined in SQL-92.

Table 8-3. SQL-92 SQLSTATE Return Codes

Class	Class Definition	Subclass	Subclass Definition
00	Successful completion	000	None
01	Warning	000	None
		001	Cursor operation conflict
		002	Disconnect error
		003	Null value eliminated in set function
		004	String data, right truncation
		005	Insufficient item descriptor areas
		006	Privilege not revoked
		007	Privilege not granted
		008	Implicit zero-bit padding
		009	Search expression too long for information schema
		00A	Query expression too long for information schema
02	No data	000	None
07	Dynamic SQL error	000	None
		001	Using clause doesn't match dynamic parameters
		002	Using clause doesn't match target specifications
		003	Cursor specification can't be executed
		004	Using clause required for dynamic parameters
		005	Prepared statement not a cursor specification
		006	Restricted data type attribute violation
		007	Using clause required for result fields
		008	Invalid descriptor count
		009	Invalid descriptor index
08	Connection Exception	000	None
		001	SQL-client unable to establish SQL-connection
		002	Connection name in use
		003	Connection doesn't exist
		004	SQL-server rejected establishment of SQL-connection
		006	Connection failure
		007	Transaction resolution unknown
0A	Feature not supported	000	None
		001	Multiple server transactions
21	Cardinality violation	000	None
22	Data exception	000	None
		001	String data, right truncation
		002	Null value, no indicator
		003	Numeric value out of range
		005	Error in assignment
		007	Invalid date-time format
		008	Date-time field overflow
		009	Invalid time zone displacement value
		011	Substring error
		012	Division by zero
		015	Internal field overflow
		018	Invalid character value for cast
		019	Invalid escape character
		021	Character not in repertoire
		022	Indicator overflow
		023	Invalid parameter value
		024	Unterminated C string
		025	Invalid escape sequence
		026	String data, length mismatch
		027	Trim error
23	Integrity constraint violation	000	None
24	Invalid cursor state	000	None
25	Invalid transaction state	000	None
26	Invalid SQL statement name	000	None
27	Triggered data change violation	000	None
28	Invalid authorization specification	000	None
2A	Syntax error or access rule violation in direct SQL statement	000	None
2B	Dependent privilege descriptors still exist	000	None
2C	Invalid character set name	000	None
2D	Invalid transaction termination	000	None
2E	Invalid connection name	000	None
33	Invalid SQL descriptor name	000	None
34	Invalid cursor name	000	None
35	Invalid condition number	000	None
37	Syntax error or access rule violation in dynamic SQL statement	000	None
3C	Ambiguous cursor name	000	None
3F	Invalid schema name	000	None
40	Transaction rollback	000	None
		001	Serialization failure
		002	Integrity constraint violation
		003	Statement completion unknown
42	Syntax error or access rule violation	000	None
44	With check option violation	000	None

---