1.mysql时间戳字段以日期格式显示

select it,FROM_UNIXTIME(clock,'%Y-%m-%d %H:%i:%s') from tb
where itemid = 36436;

2.创建库

CREATE DATABASE IF NOT EXISTS yourdbname DEFAULT CHARSET utf8 COLLATE utf8_general_ci;