<< ESF Database Convert | Home | PDFKit >>

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
272829303112
3456789
10111213141516
17181920212223
24252627282930
1234567
About
Archives
Post Categories
Blog
Lavoro
Tempo Libero
Syndication:

RSS