常用SQL语句整理

分组id.计算总和并且总和大于1的

SELECT
	bb.FBillNo,
	sum(bb.FQty) AS weight
FROM
	timefinishout bb
GROUP BY
	FBillNo
HAVING
	weight > 1

查询分组的结果插入数据库
INSERT INTO test (
	SELECT
		bb.FBillNo,
		sum(bb.FQty) AS weight,
		bb.CreateTime
	FROM
		timefinishout bb
	GROUP BY
		FBillNo
)

 

删除一段时间内的记录
DELETE
FROM
	`custdetail`
WHERE
	custdetail.InsertTime BETWEEN "2019-01-11"
AND "2019-01-12"

 

两个int类型的相连接（不是和）
SELECT
	concat(
		ltrim(monthjs.`Year`),
		ltrim(monthjs.`Month`)
	) AS months
FROM
	monthjs;