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