dopod0901 2017-03-01 11:51
浏览 68
已采纳

使用where子句mysql将数据从一个表传输到另一个表

I would like to copy data from one table to another, but placing it in a specific row. The variable is set, the tables and query are named correctly and the columns set up correctly.

I would like to select the data circled in black

enter image description here

and place it within the section circled below in black

enter image description here

The query I am using if below. When it runs without the WHERE clause it goes on the row below, when the WHERE clause is added it is blank.

$query = "INSERT INTO Results (Q1A) SELECT Q1AY FROM Answers WHERE User = $email";
  • 写回答

1条回答

      报告相同问题?

      相关推荐 更多相似问题

      悬赏问题

      • ¥30 AndroidBench&eMMC内存测试速度&Android
      • ¥15 W10 文件共享失败 怎么解决
      • ¥20 b站私信完整导出的方法
      • ¥15 边界图中的x、y轴解释
      • ¥30 如何用matlab求解复杂方程
      • ¥15 VUE TS中怎么调用第三方js
      • ¥15 Activiti如何将值传入textValue
      • ¥20 在linux里安装lummps时 在make mpi里找不到rpc
      • ¥25 python先到先得调度和轮询调度
      • ¥15 SDK Manager闪退