PHP PDOException MySql Error Codes and Messages

最新推荐文章于 2023-01-24 22:13:22 发布
最新推荐文章于 2023-01-24 22:13:22 发布
阅读量5.5k 收藏
点赞数
分类专栏： mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/mengxiangbaidu/article/details/49706037
版权

PDO Exception


PDOException extends RuntimeException {
/* Properties */
public array $errorInfo ;
protected string $code ;
/* Inherited properties */
protected string $message ;
protected int $code ;
final public string Exception::getMessage ( void )
final public mixed Exception::getCode ( void ))
}


http://php.net/manual/en/class.pdoexception.php

errorInfo
Corresponds to PDO::errorInfo() or PDOStatement::errorInfo()

code
SQLSTATE error code. Use Exception::getCode() to access it.

PDO::errorInfo — Fetch extended error information associated with the last operation on the database handle

Description ¶

public array PDO::errorInfo ( void )
Return Values ¶

PDO::errorInfo() returns an array of error information about the last operation performed by this database handle. The array consists of the following fields:

Element	Information
0	SQLSTATE error code (a five characters alphanumeric identifier defined in the ANSI SQL standard).
1	Driver-specific error code.
2	Driver-specific error message.
Note:
If the SQLSTATE error code is not set or there is no driver-specific error, the elements following element 0 will be set to NULL.
PDO::errorInfo() only retrieves error information for operations performed directly on the database handle. If you create a PDOStatement object through PDO::prepare() or PDO::query() and invoke an error on the statement handle, PDO::errorInfo() will not reflect the error from the statement handle. You must call PDOStatement::errorInfo() to return the error information for an operation performed on a particular statement handle.


PDO::errorCode

(PHP 5 >= 5.1.0, PECL pdo >= 0.1.0)
PDO::errorCode — Fetch the SQLSTATE associated with the last operation on the database handle

Description ¶

public mixed PDO::errorCode ( void )
Return Values ¶

Returns an SQLSTATE, a five characters alphanumeric identifier defined in the ANSI SQL-92 standard. Briefly, an SQLSTATE consists of a two characters class value followed by a three characters subclass value. A class value of 01 indicates a warning and is accompanied by a return code of SQL_SUCCESS_WITH_INFO. Class values other than '01', except for the class 'IM', indicate an error. The class 'IM' is specific to warnings and errors that derive from the implementation of PDO (or perhaps ODBC, if you're using the ODBC driver) itself. The subclass value '000' in any class indicates that there is no subclass for that SQLSTATE.

PDO::errorCode() only retrieves error codes for operations performed directly on the database handle. If you create a PDOStatement object through PDO::prepare() or PDO::query() and invoke an error on the statement handle, PDO::errorCode() will not reflect that error. You must call PDOStatement::errorCode() to return the error code for an operation performed on a particular statement handle.

Returns NULL if no operation has been run on the database handle.

Examples ¶

Example #1 Retrieving an SQLSTATE code

<?php
/* Provoke an error -- the BONES table does not exist */
$dbh->exec("INSERT INTO bones(skull) VALUES ('lucy')");

echo "\nPDO::errorCode(): ", $dbh->errorCode();
?>
The above example will output:

PDO::errorCode(): 42S02

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

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



Server Error Codes and Messages

https://dev.mysql.com/doc/refman/5.7/en/error-messages-server.html




coder
关注
专栏目录
MySql主从不同步原因分析及解决方案
别来沾边儿
10-10 4144
binlog日志中查询到opp_strack表的更新操作，然后对比主从库opp_strack表中字段“1683”的数据，我这边得到的数据是不一致的，发现从库opp_strack中被插入进来三条数据，冲掉了主库的id值，然后将从库中的三条数据删除掉。昨天zabbix突然发送告警信息，告警说是mysql的slave停掉了，登录到数据库从库，进去看mysql的进程是正常的，然后去看下mysql的error日志。2，根据上图的提示，查询到的异常数据出现在opp_strack表中。再次查看从库状态，恢复正常即解决。
MySql日志（六）中继日志
jinhf10的博客
12-02 2531
从数据库Slave服务的I/O线程从主数据库Master服务的二进制日志中读取数据库的更改记录并写入到中继日志中，然后在Slave数据库执行修改操作。这就是中继日志Relay Log。 mysql> show variables like '%relay%'; +---------------------------+------------------------------------------------+ | Variable_name | Value
mysql notee_MySQL 5.6.26　Release Note解读-阿里云开发者社区
weixin_36296325的博客
01-27 273
最近上游发布了MySQL 5.6.26版本，从release note来看，MySQL5.6版本已经相当成熟，fix的bug数越来越少了。本文主要分析releae note上fix的相关bug，去除performance scheama、mac及windows平台、企业版、package相关内容。InnoDB storage engine问题描述：在类unix平台上，当innodb_flush_m...
【mysql案例】mysql5.6--ERROR 1776 (HY000)-change master to遇到的报错
10-09 2856
ERROR 1776 (HY000): ParametersMASTER_LOG_FILE, MASTER_LOG_POS, RELAY_LOG_FILE and RELAY_LOG_POS cannot be setwhen MASTER_AUTO_POSITION is active.
MySQL日志管理
lpx1249115962的博客
01-24 427
*
php连mysql的工具类
05-04
在PHP开发中，连接MySQL数据库是一项基础且重要的任务。为了简化这一过程，开发者通常会创建一个工具类（Utility Class）来封装数据库连接的逻辑，提高代码的可复用性和可维护性。以下是对"php连mysql的工具类"这一...
基于PHP+MySQL实现用户注册登录功能1
08-08
$stmt = $dbh->prepare("SELECT * FROM `002` WHERE username = :username AND password = :password"); $stmt->bindParam(':username', $uname); $stmt->bindParam(':password', $hashedPwd); $stmt->execute()...
PHP8 PDO MYSQL示例
最新发布
05-18
在本文中，我们将深入探讨如何在PHP8中使用PDO（PHP Data Objects）扩展与MySQL数据库进行交互。PHP8是PHP的最新版本，提供了许多性能优化和新特性，而PDO则是一个用于数据库访问的抽象层，它支持多种数据库系统，...
php连接mysql数据库代码
12-18
在PHP编程中，连接MySQL数据库是常见的任务，用于存储和检索数据。以下是对标题和描述中涉及的知识点的详细说明： 1. **PHP与MySQL连接**：PHP是一种广泛使用的服务器端脚本语言，尤其适用于Web开发。MySQL则是一种...
测试php连接mysql是否成功的代码分享
10-26
在PHP编程中，连接MySQL数据库是一项基础操作，用于在服务器端执行SQL查询并获取数据。在遇到CMS（内容管理系统）或其他基于PHP的应用程序运行错误时，通常需要首先确认PHP是否能够成功连接到MySQL数据库，以排查...
MySQL之——主从server-id不生效，The server is not configured as slave
冰河的专栏
09-13 2万+
数据库已搭建完成，各种配置均已完成，但是在start slave ;的时候，报错： ERROR 1200 (HY000): The server is not configured as slave; fix in config file or with CHANGE MASTER TO 这里说，我没有配置为从机，但我明明配置过的啊。 MySQL版本：5.6.19 主：master I
Mysql8 MHA高可用搭建之主从复制配置
m0_67505824的博客
03-14 1418
mysql8主从配置 1、在所有主从上执行，因为每个机器都有可能使master： 2、修改所有主从的配置文件my.cnf： 3、重启这三台机器，分别执行： 4、进入slave01的mysql命令行，执行： 5、遇到的问题总结: 1、在所有主从上执行，因为每个机器都有可能使master： # mysql -u root -p -h 127.0.0.1 create user 'repl'@'%' identified with mysql_native_password by 'pass456';
mysql binlog数据恢复
GeekSnow的博客
07-18 1230
binlog的作用及开启 binlog的作用是将数据库的所有操作进行记录 而恢复数据则是将丢失的数据找到最后状态再次执行一次 是否开启binlog show variables like 'log_%'; 未开启则创建或修改/etc/my.cnf [mysqld] bind-address = 127.0.0.1 log-bin = /usr/local/Cellar/m...
MySQL 5.6.26　Release Note解读
weixin_34040079的博客
05-10 190
最近上游发布了MySQL 5.6.26版本，从release note来看，MySQL5.6版本已经相当成熟，fix的bug数越来越少了。本文主要分析releae note上fix的相关bug，去除performance scheama、mac及windows平台、企业版、package相关内容。 InnoDB storage engine 问题描述： ...
MySQL Replication--开启GTID模式下匿名事务异常
weixin_30517001的博客
05-18 708
错误环境： OS:CentOS release 6.5 (Final) MySQL: MySQL 5.7.19 主从参数配置： master_info_repository = TABLE relay_log_info_repository = TABLE gtid_mode = on enforce-gtid-consistency =...
mysql匿名事务gtid_MySQL Replication--开启GTID模式下匿名事务异常
weixin_28785657的博客
02-03 451
错误环境：OS:CentOS release 6.5 (Final)MySQL: MySQL 5.7.19主从参数配置：master_info_repository = TABLErelay_log_info_repository = TABLEgtid_mode = onenforce-gtid-consistency = truelog_slave_updates ...
MYSQL— perror 错误码详情
热门推荐
道行尚浅（老道）的博客
12-04 11万+
[root@localhost ~]# cat test_nothread.py import paramiko import threading import os def ssh2(ip,username,passwd,cmd): file_path='/root/perror.log' logfile=file(file_path,'a') try:
mysql错误码解释
weixin_33910434的博客
12-25 6586
OS error code 1: Operation not permitted OS error code 2: No such file or directory OS error code 3: No such process OS error code 4: Interrupted system call OS error code 5: Inp...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值