MySQL连表插入

MySQL连表插入

SELECT
	@val := field_name1
FROM
	table_name1
WHERE
	field_name = field_value;

INSERT INTO table_name2 (field_name1, field_name2)
VALUES
	(@val, field_value2);

SELECT
	LAST_INSERT_ID() INTO @id;

INSERT INTO table_name3 (field_name1, field_name2)
VALUES
	(@id, field_value2);

• 从数据库中查询一个值 @val
• LAST_INSERT_ID() 获取最后一个插入ID值 @id