Is there any source, where I can get list of all errorCode/errorMessage in MySQLException (io.vertx.mysqlclient)

For ex:

1062 is MySQL Duplicate Key

CodePudding user response：

While you asked for vert.x codes, probably source material- MySql Error reference would help https://dev.mysql.com/doc/mysql-errors/8.0/en/ There are server and client side as well as global error codes listed there.

Also, check out https://github.com/sambrmg/mysql-error-codes/blob/master/index.js

CodePudding user response：

In MySQL %s represents a String ID and %d is representing a primary key(usually) decimal. 1062 is about an identical column value as an id column or such like. https://dev.mysql.com/doc/mysql-errors/8.0/en/client-error-reference.html Get the PDF download of this page in the left column of all the error codes. note: If you use PHP it has similar numeric error messages (just to not confuse it). note: https://dev.mysql.com/doc/mysql-errors/8.0/en/server-error-reference.html