Quick SQL Help Chalanachithram.com | Topics | Search
Hide Clipart | Log Out | Register | Edit Profile

Last 30 mins | 1 | 2 | 4 hours     Last 1 | 7 Days

Chalanachithram.com DB » TF Industry related » Archive through October 23, 2012 » Quick SQL Help « Previous Next »

Author Message
Top of pagePrevious messageNext messageBottom of page Link to this message

Pavala
Hero
Username: Pavala

Post Number: 16268
Registered: 02-2008
Posted From: 193.47.71.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, October 23, 2012 - 07:46 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

plty tamud
but if alright tho manage sesetodini...sql, pql ante naakem vachu...kish burra meedha bochu thappa
ravi ni mana samajam full ga vaaduku dobbi eppudu rowdy ante ela. - Diviseema
Danush gadi acting ni match chesetollu mana telugu lo evaroo leranukunta - Kfpremium
Top of pagePrevious messageNext messageBottom of page Link to this message

Gotcha
Side Hero
Username: Gotcha

Post Number: 9424
Registered: 02-2008
Posted From: 66.50.246.102

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, October 23, 2012 - 07:46 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

Why are not using join?
This real estate is for sale.
Top of pagePrevious messageNext messageBottom of page Link to this message

Platypus
Comedian
Username: Platypus

Post Number: 1136
Registered: 01-2008
Posted From: 106.207.202.185

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, October 23, 2012 - 07:43 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

Already ettaanu mama. Meerevaru chadavaledu anthe :D :D

BTW, Problem resolved. Don't bother answering this question.
Naaku nacchindi janaalaki nacchadu... Janaalaki nacchindi naaku nacchadu... Nenanthe.. adho type.
Top of pagePrevious messageNext messageBottom of page Link to this message

Pavala
Hero
Username: Pavala

Post Number: 16267
Registered: 02-2008
Posted From: 193.47.71.253

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, October 23, 2012 - 07:26 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

plty tamud
cmgr reiew ettu....but mee fav bogusman tho no comparison plz
ravi ni mana samajam full ga vaaduku dobbi eppudu rowdy ante ela. - Diviseema
Danush gadi acting ni match chesetollu mana telugu lo evaroo leranukunta - Kfpremium
Top of pagePrevious messageNext messageBottom of page Link to this message

Platypus
Comedian
Username: Platypus

Post Number: 1135
Registered: 01-2008
Posted From: 106.207.202.185

Rating: N/A
Votes: 0 (Vote!)

Posted on Tuesday, October 23, 2012 - 07:23 am:   Insert Quote Edit PostDelete PostPrint Post   Move Post (Moderator/Admin Only)Ban Poster IP (Moderator/Admin only)

What is wrong with the following query in MySQL?

update wp_posts
set comment_count = B.comment_count
from wp_posts A,
(SELECT comment_post_id, COUNT( 1 ) comment_count
FROM wp_comments
GROUP BY comment_post_id) B
where A.ID = B.comment_post_id

Please help. It says syntax incorrect. I don't have a MySQL DB right now where I can test the syntax. Need to directly do it on the live database. (Kompalu monige Db kaadule.. my personal blog site DB)
Naaku nacchindi janaalaki nacchadu... Janaalaki nacchindi naaku nacchadu... Nenanthe.. adho type.

Add Your Message Here
Post:
Bold text Italics Underline Create a hyperlink Insert a clipart image HASH(0x8ad11b4){Movie Clipart}
Show / Hide regular icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

 N   O   P   Q   R   S   T   U   V   W   X   Y   Z  

Show / Hide Filmy icons selection options

Click on following links to open cliparts by Alphabetical Order

 A   B   C   D   E   F   G   H   I   J   K   L   M  

 N   O   P   Q   R   S   T   U   V   W   X   Y   Z  


Username: Posting Information:
This is a public posting area. Enter your username and password if you have an account. Otherwise, enter your full name as your username and leave the password blank. Your e-mail address is optional.
Password:
E-mail:
Options: Enable HTML code in message
Automatically activate URLs in message
Action: