rpnew
Last Activity: Apr 2 '18, 04:13 PM
Joined: Aug 22 '07
Location:
-
Glad that it helped.. -
Hi Kelvinejimogu,
This part in your query should have alias
LikeCode:SELECT `Post_id`, COUNT(`Comm_id`) AS `total_comments`, MAX(`comm_date`) AS `last_comment` FROM `comments
BTW I don't see condition for your LEFT join either on which you are joining with...Code:(SELECT `Post_id`, COUNT(`Comm_id`) AS `total_comments`, MAX(`comm_date`) AS `last_comment` FROM `comments) tab1
Leave a comment:
-
Okay.. but so far it looks okay.. The report will go into testing now so will see once it is tested.. and thanks for the reply once again..
Regards,
RPLeave a comment:
-
Hi Rabbit,
Agreed.. that there is now way to check the order in which the rows were entered but thats not the issue. We can for example sort the output by ID and use the output.
BTW, I got the output which i wanted by using GROUP_CONCAT() and then SUBSTRING_INDEX () however just wanted to know.. how much will this affect performance of qeury. Although, i dont see much issue there but just to get some idea..
Regards,...Leave a comment:
-
Hi,
Let say.. first entries for each IDs should be first row... second entries for each IDs should be second row.. third entries of each IDs should be third row.. and so on..
Regards,
RPLeave a comment:
-
Hi Rabbit,
let me put my ouput in another way...
"id" "age"
----------
"1" "0"
"2" "0"
"3" "0"
"4" "0"
"5" "0"
"1" "11"
"2" "30"
"3" "1"
"4" "1"
"5"...Leave a comment:
-
Hi Rabbit,
Yeah.. sorry my mistake.... you are right.. Required ouput is something like this..
ID 1 2 3 4 5
AGE 0 0 0 0 0
AGE 11 30 1 1 1
Regards,
RPLeave a comment:
-
Okay.. let me explain a bit more..
I suppose output is not much difficult to understand.. now my requirement is to change column into rows..
right now query output is
id" "age"
"1" "0"
"1" "11"
"2" "0"
"2" "30"
"3" "0"
"3" "1"...Leave a comment:
-
Any suggestions for above.. i need to complete one report?Leave a comment:
-
Transpose Query Output
Hi All,
It feels so good to be back on Bytes after almsot 2-3 years.. anyways here is my quesion. I would like to transpose my query output.
here are the details..
*** Tables
GDCA
gdcid,gdcid,gda id,age
GDA
gdaid,name
*** Queries
SELECT
gda.id,age
FROM
gdca
JOIN gda ON (gda.id = gdca.gdaid)... -
Hi,
I'm not sure if i could help you or not.. but could you provide more information like.. your table structure, your materialized view query and all.... so that we would be able to get more insight on your problem.
Thanks,
RPLeave a comment:
-
Hi,
Well i have done the partition now. I was not able to make extended partition through Windows so i used one third party software- Paragon Hard Disk Manager -
and through that i was able to make extended partition.
Thanks,
RPLeave a comment:
-
Hi,
I have already seen the page you have given but when i try to do it that way it wont allow me to create a new partition and it is not creating a new extended partition as well. Regarding Diskpart i tried hands on it but i seem not understanding it properly. As it is not working for me. Can you provide some good tutorial on Diskpart..
Thanks,
RPLeave a comment:
-
Hi,
Well through Windows partition manager i was not able to shrink C drive after some limit so i used BootItNg to make C drive according to what i wanted. Then i used windows partition manager to make another 50 GB partition. But then i cant do anything with remaining unallocated space of about 120+ GB neither with BootItNg nor with window partition manger. As per what i learn from Net i can not make further Primary partition and...Leave a comment:
-
Hi YarrOfDoom,
Well i used BootitNg to first trim my C drive now i have drives as below.
C - 50 GB
D - 10 GB (Recovery)
F - 50 GB (Empty)
and then 120+ GB unallocated.
When i try to make new volume from this unallocated space it would not allow me giving error " You can not create a new volume in this unallocated space because the disk already contains the maximum number of partitions" . Any help...Leave a comment:
-
Make partition of Harddisk on Vista
Hi All,
i recently got new Compaq laptop- CQ 45-106 AU (If i'm not wrong- will update it after reaching home.). Now i have two questions regarding this.
First one is i want to make partition of my hard disk. My laptop harddisk is around ~ 250GB. Now i would like to make partition of lets say 50GB each. Presently there are two partitions.One is of recovery and that is of 10 GB and rest is allocated to C drive. Now what... -
Hi,
thanks for the reply.. i think for both of my cases i need to reconfigure my PHP mostly to newer version..
Regards,
RP...Leave a comment:
-
Hi,
Thanks for the reply.. i'll look into that...
Regards,
RP...Leave a comment:
-
Call to undefined function: mysql_connect()
Hi,
well i know that i've some problem here with php and mysql.. mainly with php compilation with mysql...
now i've "php 4.2.2" on server... and "mysql Ver 14.12 Distrib 5.0.24, for pc-linux-gnu (i686) using readline 5.0"
- when i run phpinfo() it shows
--with-mysql=shared,/usr but no mysql related other info - when i run php from commandline then it shows following error "PHP
- when i run phpinfo() it shows
-
welcome,
Glad that you found solution.
come back whenever you have problem.
Regards,
RP...Leave a comment:
No activity results to display
Leave a comment: