mysql导出语句

#导出表格语句

SELECT
	CONVERT ((@rowNo :=@rowNo + 1), CHAR(10)) AS rowNo,
	a.*
FROM
	(
		SELECT
			date_format(t.investExpireDate, '%Y/%m/%d') AS investExpireDate,
			t.staffName,
			t.userPhone,
			t.branchDepName,
			t.addAmount,
			(IFNULL(t.specialAmount, 0) + IFNULL(t.companySpecialAmount, 0)) AS specialAmount,
			t.bankCity
		FROM
			t_jt_contract_data t
		INNER JOIN t_jt_contract_front_map m ON m.contractId = t.id
		WHERE
			t.insertFlag = 2
		AND t.contractFlag IN (2, 3)
		AND t.redemption = 2
		ORDER BY
			t.contractTime
	) a,
	(SELECT @rowNo := 0) AS it;