当前位置:Gxlcms > 数据库问题 > mysql 多表插入

mysql 多表插入

时间:2021-07-01 10:21:17 帮助过:12人阅读

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;

  1. <span style="color: #0000ff;">INSERT</span> <span style="color: #0000ff;">INTO</span> <span style="color: #ff00ff;">user</span> (username,pswd) <span style="color: #0000ff;">VALUES</span> ("张三","<span style="color: #800000; font-weight: bold;">123</span><span style="color: #000000;">");
  2. </span><span style="color: #0000ff;">SET</span> <span style="color: #008000;">@id</span> <span style="color: #808080;">=</span><span style="color: #000000;"> LAST_INSERT_ID():
  3. </span><span style="color: #0000ff;">SELECT</span> <span style="color: #008000;">@id</span><span style="color: #000000;">;
  4. </span><span style="color: #808080;">OR</span>
  5. <span style="color: #0000ff;">SELECT</span> LAST_INSERT_ID():

 

 

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

  

mysql 多表插入

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

人气教程排行