Cross Table Update with MySQL

ho fatto un progetto in cui il database era mysql, e la sintassi per un update con tabelle in join è la seguente

UPDATE product p, productPrice pp
SET pp.price = pp.price * 0.8
WHERE p.productId = pp.productId

posted @ lunedì 23 giugno 2008 01:22

Print

Comments on this entry:

# re: Cross Table Update with MySQL

Left by he at 13/11/2014 18:27
Gravatar
becoming potent mobile check my credit score monetary sharply ebbs and flows 3 credit report scores perspective partners 5

# Mulberries

Left by Mulberries at 16/08/2018 19:20
Gravatar
Going to graduate school was a positive decision for me. I enjoyed the coursework, the presentations, the fellow students, and the professors. And since my company reimbursed 100% of the tuition, the only cost that I had to pay on my own was for books and supplies. Otherwise, I received a free master’s degree. All that I had to invest was my time. Mulberries

# Rice

Left by Rice at 16/08/2018 22:08
Gravatar
This is such a great resource that you are providing and you give it away for free. Rice
Comments have been closed on this topic.
«novembre»
domlunmarmergiovensab
25262728293031
1234567
891011121314
15161718192021
22232425262728
293012345