摘要:
@JSON(format="yyyy-MM-dd") public Date getCreatDate() { return creatdate; } @JSON(format="yyyy-MM-dd hh-mm-ss") public Date getCreatDate() { return cr 阅读全文
摘要:
查询排行及所有(表名.*) 1. set @rownum=0; SELECT @rownum:=@rownum+1 AS top, customer.* FROM customer 2. SELECT @rownum:=@rownum+1 AS top, customer.* FROM (SELEC 阅读全文
摘要:
给现有的wxinfo表的sourceUrl 字段创建全文索引 ALTER TABLE wxinfo ADD FULLTEXT INDEX sourceUrl (sourceUrl) 创建全文索引前: SELECT * FROM wxinfo WHERE sourceUrl LIKE '%查询字符串% 阅读全文