welcome to my home in cyberspace, ....
While trying to run a codeigniter app the other day I came across this error just after I had finished uploading the files and making the ne...
UPDATE product INNER JOIN product_price ON product.productId = product_price.productIdSET product_price.price = product_price.price * 1.5WHERE product.dateCreated < '2009-10-23'
Woks like a charm...Thanks
you are welcome
Thanks, that was useful. The MySQL documentation is lacking a decent basic example like this.
You're welcome, i'm glad the sample helped you.
Hi , if I had zero at the left like 0015.. how it will keep zero instead 15?.Thank you
hi @anonymous, may you please give an example as i'm not quite sure i get your question.
I have been looking for this query forever, couldn't even find it in any books. Thank you.
You're welcome, i also had been looking for a while for thiss so when i found it i decided to post it here.
I found this blog on time, it's saves lot of my time. Thank you very much for sharing with us.
you are really "Blessed"!I'm still learning mySQL.I just thought this was impossible... and then I found this page..Thanks!
glad you found this helpful :)
Perfect example.. Thank You.
You are very welcome