INSERT and UPDATE

The type will be converted to the type of the column affected.

CREATE TABLE t(i INT);

INSERT INTO t VALUES('123');

 

SELECT * FROM t;

 

            i

=============

          123