Mysql常用sql(函数)
1、查询当天数据
select * from tableName where to_days(create_date) = to_days(now());
2、BLOB类型字段
message为blob类型,查询为:
SELECT concat(message, '') from msg_info;
Mysql常用sql(函数)
1、查询当天数据
select * from tableName where to_days(create_date) = to_days(now());
2、BLOB类型字段
message为blob类型,查询为:
SELECT concat(message, '') from msg_info;