Mysql数据类型

 

create table t_dt(coll datetime);
desc  t_dt;
insert into t_dt values("2020-3-13");
insert into t_dt values("20-3-13");
insert into t_dt values("20$3$13");

create table tt(coll timeStamp);
insert into tt values(now());//系统时区

create table t_t1(cool1 char(4),coll2 varchar(4));
insert into t_t1 values ('ab  ','ab  ');
insert into t_t1 values('abcd','abcd');
insert into t_t1 values('abc','abc');

create table t2(coll text);
insert into t2 values('abcdefg'),('ABCDEFG');

create table t3(id int,name varchar(10),sex enum('F','M','UN'));//枚举类型 插入数据要在选项当中并且不可以插入空值
INSERT INTO t3 values(1,'ljw','F');

create table t4(coll1 set('a','b','c'));//多项选择
insert into t4 values ('a');
insert into t4 values ('a,b');
insert into t4 values ('a,b,c');


select concat(cool1,'!'),concat(coll2,'!') from t_t1;
select cool1,length(cool1),coll2,length(coll2) from t_t1;//字符长度
select * from t2 where coll  like 'a%';//text类型在查询的时候不区分大小写