mysql 多表插入

INTO user (username,pswd) VALUES ("张三","123"); SET @id = LAST_INSERT_ID(): INSERT INTO user_info (u_id,phone,email) VAULES (@id,"13145678895","xasd@qq.com");

插入查询id;

INSERT INTO user (username,pswd) VALUES ("张三","123");

SET @id = LAST_INSERT_ID():
SELECT @id;

OR 

SELECT LAST_INSERT_ID():

 

 

不过需要注意,只有主键才能进行该操作

　　

mysql 多表插入

标签：假设   有一个   插入   用户   span   select   name   style   hone