How to combine these both Query into Single Query
$sql = "INSERT INTO deletedtemplate (template) SELECT template FROM template WHERE id = $id";
$sql1 = "DELETE FROM template WHERE id = $id ";
Add a comment
|
3 Answers
Simply you can combine these both query using this:
$sql = "INSERT INTO deletedtemplate (template) SELECT template FROM template WHERE id = $id; DELETE FROM template WHERE id = $id ";
answered May 11, 2015 at 5:37
Kalaiselvan Mahendiran
9964 gold badges14 silver badges25 bronze badges
1 Comment
Tech Savant
heck i coulda told you that. I didn't realize that was an acceptable answer. haha :) as its not actually one query but two. The first query ends at the semi-colon. :) I'll shoot you the upvote anyway.
You can not have these 2 queries together, however the same could be handled via trigger something as
delimiter //
create trigger template_del before delete on template
for each row
begin
insert into deletedtemplate (template)
SELECT template FROM template WHERE id = old.id ;
end;//
delimiter ;
So if you delete something on template an insert will happen on the deletedtemplate table
2 Comments
Kalaiselvan Mahendiran
if i put this code in function am getting error as unexpected create
Abhik Chakraborty
You can't put this into your PHP code, you need to add this directly into mysql.
Try this... and maybe make the name of your field different than the name of your table... so table would still be template, but change the field currentTemplate or something like that. I'm not sure if that might be causing any issues but it makes it less confusing to read/edit the query that's for sure.
REPLACE INTO
`deletedtemplate`
(`template`)
select
`template`
from
`template`
where
`id` = $id;
8 Comments
Kalaiselvan Mahendiran
am getting this Error : SQLSTATE[42000]: Syntax error or access violation: 1064 'as d, template as t (d.template) values (t.template) where t.id = 5' at line 1
Tech Savant
Posted an update, my query syntax was wrong, can you try the new query I posted. @KalaiS
Kalaiselvan Mahendiran
here record is moving to another table, but current table data not getting delete
Tech Savant
So it's inserting just not deleting AND your getting an error?
Tech Savant
Can you post the new error so I can see where in the query it's getting mad.
|