我试图将字段从一个表移动到另一个表,然后从第一个表中删除它。我遇到的问题是它可以很好地移动数据,但不会从第一个表中删除它。
这是我的代码:
"INSERT INTO out_tickets SELECT * FROM tickets";
"DELETE FROM tickets WHERE * FROM tickets";
不确定我做错了什么?
EDIT
更新的代码:
<?php
// Process delete operation after confirmation
if(isset($_POST["id"]) && !empty($_POST["id"])){
// Include config file
require_once 'config.php';
// Prepare a select statement
$sql = "INSERT INTO out_tickets SELECT * FROM tickets";
"DELETE FROM tickets";
if($stmt = mysqli_prepare($link, $sql)){
// Bind variables to the prepared statement as parameters
mysqli_stmt_bind_param($stmt, "i", $param_id);
// Set parameters
$param_id = trim($_POST["id"]);
// Attempt to execute the prepared statement
if(mysqli_stmt_execute($stmt)){
// Records deleted successfully. Redirect to landing page
header("location: technical.php");
exit();
} else{
echo "Oops! Something went wrong. Please try again later.";
}
}
据我了解你正试图移动ALL列从一个表 (t1) 到另一个表 (t2) 具有相同的结构(或到表,包含与第一个相同的列),并且您想要从 table1 中删除移动到 t2 的数据?
如果正确则使用下一个 SQL
INSERT INTO t2 SELECT * FROM t1;
DELETE FROM t1 WHERE 1;
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)