风之影

createtime+INTERVAL "+1+" month   (createtime  + INTERVAL 1  month)-INTERVAL (day(createtime) -1) day

DATE_FORMAT(d.createtime,'%Y-%m')

用MYSQL截取字符串   SELECT title,IF(CHAR_LENGTH(title)>10,CONCAT(LEFT(title,8),'...'),title) AS dispaly_titile FROM article ;

SELECT * FROM `t_order` where (('2008-01-08'>=startDate) and ( '2008-01-03'<=startDate)) or (('2008-01-03'<=endDate) and ('2008-01-08'>=endDate)) or (('2008-01-03'>=startDate) and ('200...