Update and insert in one query mysql

The best answers are voted up and rise to the top. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Learn more. Asked 10 years, 6 months ago. Active 5 years, 3 months ago.

Viewed 6k times. Improve this question. Saravanan Saravanan 3 3 gold badges 8 8 silver badges 12 12 bronze badges. Add a comment. Active Oldest Votes. Observe the below query. To have a better understanding of the concept, let us re-run the same query, this time.

Your email address will not be published. This site uses Akismet to reduce spam. Learn how your comment data is processed.

Related Posts. Leave a Comment Cancel Reply Your email address will not be published. First of all you have to have triggers created before you issue any insert or delete statements on orders table.

If want to create your triggers from php you have to execute each query one at a time. Ok, I am a bit confused, but want to know how to do this so il try and implement it. What exactly are you confused with? You create triggers once the same way you create tables. And then just do your inserts and deletes from your application client code as usual. Ok so create triggers in myphpadmin, then insert and delete statement on the php end.

Show 7 more comments. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. It is quite powerful and fast. We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge. You're trying to visit a URL that doesn't currently exist on the web. Most likely, a member posted a link a long time ago to a web page that has since been removed.

It's also possible that there was a typo when posting the URL. We redirect you to this notice instead of stripping out the link to preserve the integrity of the post. Hi there I'd like to know if it's possible to combine an update and insert query into one query. Would I join the 2 queries with AND? Answered by nav33n in a post from 13 Years Ago. The only case where you can have insert and update in the same query is when you use Jump to Post.