时间:2021-07-01 10:21:17 帮助过:12人阅读
插入查询id;
- <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;">");
- </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():
- </span><span style="color: #0000ff;">SELECT</span> <span style="color: #008000;">@id</span><span style="color: #000000;">;
- </span><span style="color: #808080;">OR</span>
- <span style="color: #0000ff;">SELECT</span> LAST_INSERT_ID():
不过需要注意,只有主键才能进行该操作
mysql 多表插入
标签:假设 有一个 插入 用户 span select name style hone