• corresponding SQLSTATE values general error


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

    B.3 Server Error Codes and Messages

    MySQL programs have access to several types of error information when the server returns an error. For example, the mysqlclient program displays errors using the following format:

    shell> SELECT * FROM no_such_table;
    ERROR 1146 (42S02): Table 'test.no_such_table' doesn't exist

    The message displayed contains three types of information:

    • A numeric error code (1146). This number is MySQL-specific and is not portable to other database systems.

    • A five-character SQLSTATE value ('42S02'). The values are taken from ANSI SQL and ODBC and are more standardized. Not all MySQL error numbers have corresponding SQLSTATE values. In these cases, 'HY000' (general error) is used.

    • A message string that provides a textual description of the error.

  • 相关阅读:
    Kubernetes之Replica Set
    Kubernetes之Replication Controller
    Kubernetes之Deployment
    golang channel select
    golang slice
    epoll的由来
    ceph crush 之 crush_do_rule
    libevent
    P2P资料
    混沌理论学习笔记
  • 原文地址:https://www.cnblogs.com/rsapaper/p/6215111.html
Copyright © 2020-2023  润新知