When I update a tinyint column by using the following statement, it looks like weird.
The execution result is different from mysql cli.So I'm not sure whether it is a bug or special design and I look for the document but don't find any useful information about this case.
mysqld version:
my table structure
using mycli to update the col_tinyint column
using mysql cli to update the col_tinying column
Because the default range of tinyint type column is -128~127, I think this update statement should execute failed rather than give a max value and execute succeed.
I'm trying use SET sql_mode = 'TRADITIONAL'; in mycli, then the result is same as mysql cli. Dose mycli set some default values in sql_mode?
When I update a tinyint column by using the following statement, it looks like weird. The execution result is different from mysql cli.So I'm not sure whether it is a bug or special design and I look for the document but don't find any useful information about this case.
mysqld version:
my table structure
using mycli to update the col_tinyint column
using mysql cli to update the col_tinying column
Because the default range of tinyint type column is -128~127, I think this update statement should execute failed rather than give a max value and execute succeed.
I'm trying use SET sql_mode = 'TRADITIONAL'; in mycli, then the result is same as mysql cli. Dose mycli set some default values in sql_mode?