I have a table - 'A' which has primary key - id which is auto incremented.I also have a table - 'B' which also has the column 'id'. Now I want to add entries to the table A so that value of id attribute of table 'A' which just got inserted to the table also gets inserted to B while other attributes of B can remain NULL.I know I can just make one table with all the columns but is there a way to do this with two tables??
1条回答 默认 最新
douping7975 2015-10-22 17:52关注Use the mysqli_insert_id () function right after you run the insert to table a. That will give you the value of the auto incremented id from table a which you can then populate in the surrogate key column of table b.
Read about it here: http://php.net/manual/en/mysqli.insert-id.php
本回答被题主选为最佳回答 , 对您是否有帮助呢?解决 无用评论 打赏举报
分享
- 2013-09-28 04:38回答 7 已采纳 Assuming that you are using InnoDB engine (which is default in most recent MySQL versions), you sh
- 2014-06-26 10:28回答 1 已采纳 Your content probably contains quote characters, which you need to escape. $bcontent = mysql_real
- 2022-03-21 23:23回答 6 已采纳 <?php $con = mysqli_connect("sever","user","passwd"); if (!$con) { die('Could not connect: ' . my
- 2020-01-15 09:18追梵宇的博客 直接在命令行运行php (设置php最大运行时间为0, 设置php执行内存为-1) max_execution_time = 0 php内存占用 1为不限 memory_limit = -1 mysql 内存执行 max_allowed_packet = 10000M ...
- 2019-01-11 15:19回答 1 已采纳 use mysql_insert_id();, you find the doc here
- 2014-04-17 18:51回答 2 已采纳 Many typos - 1) Put empty string in place of 1st empty , in values 2) Remove ] from last value 3)
- 2019-12-27 23:55回答 2 已采纳 可以了解一下mysql的COLLATE（效验规则）。默认的XXX_ci 是不区分大小写和是否携带声调的 。 只要把对应的字段或表的校验规则COLLATE设置为XXX_bin就会解决你说的问题。
- 2022-04-20 14:53didi558的博客 1.对查询进行优化，应尽量避免全表扫描，首先应考虑在 where 及 order by 涉及的列上建立索引。 2.应尽量避免在 where 子句中对字段进行 null 值判断，否则将导致引擎放弃使用索引而进行全表扫描，如：select id ...
- 2022-03-10 11:43回答 1 已采纳 你是只需要一个汇总sql,还是要用sql输出json数组？还有你mysql的版本是多少？假设只是汇总数据 select sum(今日上报) 今日上报, sum(办理中) 办理中, sum(待受理)
- 2014-10-14 10:35回答 1 已采纳 Try this code: mysql_query("UPDATE table_name SET field_name = '" .$str_value."' WHERE $field
- 2014-05-20 07:32回答 1 已采纳 Looks like your table is missing the indexes and if yes you need to add them first. Before adding
- 2023-03-22 20:32csdn9645的博客 通过 array_chunk 分批处理。
- 2014-12-16 12:30回答 6 已采纳 SELECT T2.* FROM user_list T1 INNER JOIN 201411 T2 ON T1.username = T2.username
- 2018-10-15 17:33xudejun的博客 php向mysql插入百万数据只需不到一分钟时间，之间还可以优化 <?php set_time_limit(0); $dsn = 'mysql:dbname=test;host=localhost;port=3306'; $username = 'root'; $password = '123456'; try { $pdo = ...
- 2021-02-07 14:56weixin_32243075的博客 //如果没有找到$key,就将该查询sql的结果缓存到redis while ($row = mysql_fetch_assoc($result)) { $redis->set($row['id'],$row['name']); } $myserver = 'mysql'; break; } else { $myserver = "redis"; ...
- 没有解决我的问题, 去提问
悬赏问题
- ¥50 silvaco GaN HEMT有栅极场板的击穿电压仿真问题
- ¥15 谁会P4语言啊，我想请教一下
- ¥20 win11无法启动 持续蓝屏且系统还原失败，无法开启系统保护
- ¥15 哪个tomcat中startup一直一闪而过 找不出问题
- ¥15 这个怎么改成直流激励源给加热电阻提供5a电流呀
- ¥50 求解vmware的网络模式问题 别拿AI回答
- ¥24 EFS加密后，在同一台电脑解密出错，证书界面找不到对应指纹的证书，未备份证书，求在原电脑解密的方法，可行即采纳
- ¥15 springboot 3.0 实现Security 6.x版本集成
- ¥15 PHP-8.1 镜像无法用dockerfile里的CMD命令启动 只能进入容器启动，如何解决？(操作系统-ubuntu)
- ¥30 请帮我解决一下下面六个代码