Mysql SELECT 查询 UNIXTIME 时间戳 转 年-月-日 时:分:秒
SELECT TIMESTAMPDIFF(YEAR, FROM_UNIXTIME(inputtime,'%Y-%m-%d %H:%i:%S'), NOW( ) ) AS time FROM
Mysql SELECT 查询 CONCAT 补全信息 -月-日 时:分:秒
SELECT TIMESTAMPDIFF(YEAR,CONCAT(`year`,'-01-01 00:00:00'), NOW()) AS time FROM
Mysql SELECT 查询 SUBSTRING_INDEX 分割字符串
SELECT SUBSTRING_INDEX(a.`storey`,'|',1) FROM
Mysql SELECT 条件查询表内容 并导出到新表内容
INSERT INTO database.table2 (id,title,content,time) SELECT * FROM (SELECT id,title,content,time FROM database.table1 WHERE title LIKE '%keyword%') AS tb