drop table if exists t1 ;
create table t1
( c1  tinyint, c20 char(2), c21 char(100), primary key(c1)) ;
insert into t1 ( c1, c20, c21 ) values ( 50, '500', '500' ) ;
Warnings:
Warning	1265	Data truncated for column 'c20' at row 1
insert into t1 ( c1, c20, c21 ) values ( 51, 500, 500 ) ;
Warnings:
Warning	1265	Data truncated for column 'c20' at row 1
insert into t1 ( c1, c20, c21 ) values ( 52, -5.0E+2, -5.0E+2 ) ;
Warnings:
Warning	1265	Data truncated for column 'c20' at row 1
set @arg00= 500.0 ;
insert into t1 ( c1, c20, c21 ) values ( 53, @arg00, @arg00 ) ;
Warnings:
Warning	1265	Data truncated for column 'c20' at row 1
insert into t1 ( c1, c20, c21 ) values ( 54, 500.0, 500.0 ) ;
Warnings:
Warning	1265	Data truncated for column 'c20' at row 1
insert into t1 ( c1, c20, c21 ) values ( 55, +5.0E+2, +5.0E+2 ) ;
Warnings:
Warning	1265	Data truncated for column 'c20' at row 1
insert into t1 ( c1, c20, c21 ) values ( 56, +5000E+2, +5000E+2 ) ;
Warnings:
Warning	1265	Data truncated for column 'c20' at row 1
select * from t1;
c1	c20	c21
50	50	500
51	50	500
52	-5	-500
53	50	500
54	5e	500
55	5e	500
56	5e	500000