Mysql Insert Select

INSERT INTO 
	camera 
		( camera_name, lon, lat, direction, stake_num ) 
SELECT
	remark camera_name,
	lon,
	lat,
	direction,
	stake_num 
FROM
	stake 
WHERE
	type = 'xxx'

注意字段的映射