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.
«giugno»
domlunmarmergiovensab
2930311234
567891011
12131415161718
19202122232425
262728293012
3456789