Re: Can insert update a table based on match of one column value?

[Peter Brawley]

> I saw people doing very complicated things in one single query

Some complicated things can be done in one query, esp. with common table expressions. Your wee job needs a transaction, control flow and multiple statements.

> the stored procedure surely the performance should be better then the sql query right?

No, mysql sprocs usually do not improve performance.