Simple is Hard

1. mariadb download https://tw1.mirror.blendbyte.net/mariadb/mariadb-10.11.3/bintar-linux-systemd-x86_64/mariadb-10.11.3-linux-systemd-x86_64.tar.gz wget https://tw1.mirror.blendbyte.net/mariadb/mariadb-10.11.3/bintar-linux-systemd-x86_64/mariadb-10.11.3-linux-systemd-x86_64.tar.gz shell> groupadd mysql shell> useradd -g mysql mysql shell> cd /usr/local shell> gunzip ln -s full-path-to-mariadb-V..

create table test_num ( var1 numeric(10,3) ) ; insert into test_num ( var1 ) values ( 10.12); select var1 + 1 from test_num select var1 + 10.2 from test_num select var1 + cast ( to_number('10.23','00.00') as numeric(10,4) ) from test_num select to_number('10.23','00.000') from db_root create table test_data1 ( var1 numeric(10,0) , var2 integer ); insert into test_data1 ( var1, var2 ) values ( 10..