use test;

--disable_warnings
drop table if exists t1;
--enable_warnings

create table t1 (
  insert_value CHAR(30),
  str2int INT, num2int INT,
  str2decimal DECIMAL(10), num2decimal DECIMAL(10) );

insert into t1
values ( '1000000', '1000000', 1000000, '1000000', 1000000 ) ;
insert into t1
values ( '2.0e+6', '2.0e+6', 2.0e+6, '2.0e+6', 2.0e+6 ) ;
insert into t1
values ( '3.0e6', '3.0e6', 3.0e6, '3.0e6', 3.0e6 ) ;
insert into t1
values ( '+4.0e+6', '+4.0e+6', +4.0e+6, '+4.0e+6', +4.0e+6 ) ;
--vertical_results
select *, '---------------------' from t1 ;
--horizontal_results