Sample Data for Casting in SQL

cast_ex_sample_data.sql

create database if not exists cast_ex;
create table if not exists cast_ex.table_1 (
  val_int int(10) not null,
  val_int_char varchar(10) not null,
  val_str varchar(10) not null
);

insert into cast_ex.table_1
with recursive seq 
  as (
     select 1 as val union all
     select val + 1 
       from seq
      where val < 1000
     )
select val as val_int,
       cast(val as char) as val_str,
       substring(md5(val),1,10) as val_str
  from seq;