1. numeric
2. date time
3. string

numberic
--
drop table if exists test;
create table test (h int, w float);
insert into test values (173, 55.12345); select * from test;

drop table if exists test;
create table test (h int, w float(7,5));
insert into test values (173, 55.12345); select * from test;


datetime
--
drop table if exists test;
create table test (d date);
insert into test values ('2017/1/1'); select * from test;
insert into test values ('2017-2-2'); select * from test;

drop table if exists test;
create table test (t time, dt datetime);

string
--
drop table if exists test;
create table test (a varchar(4), b text);
insert into test values ('abcdef', 'ABCD一二三四'); select * from test;