Page 1 of 1
Please, help me or I will smash my computer!
Posted: Sun Nov 04, 2007 7:22 am
by scepanmali
OK, here is the problem:
I use Mysql and I have 5 tables in database. How to sum rows in all of them to get
total number of rows! Example: In one of them I have 20 rows. In the second one I have
10 and so on. I want to produce one number of 30! It's not problem to count rows
in one table, but in all 5 of them...
PLEASE, IF SOMEONE KNOWS HOW TO DO THAT, I will be very thankful!
Thank You in advance

Descriptive Subjects
Posted: Sun Nov 04, 2007 7:24 am
by feyd
If this is throwing you into a fit, I'd stop now.
Re: Descriptive Subjects
Posted: Sun Nov 04, 2007 1:02 pm
by scepanmali
feyd wrote:If this is throwing you into a fit, I'd stop now.
OK, if you don't want to help me, don't talk with me and go to another place!
Stay out of my thread! I am a beginner, so if you have problem with that, almighty YOU, go away and let other GOOD people to help! Good bye!
Posted: Sun Nov 04, 2007 1:42 pm
by neophyte
where's the smashed computer?
Posted: Sun Nov 04, 2007 4:53 pm
by Benjamin
LOL
Code: Select all
select (select count(*) from table_one) + (select count(*) from table_two) + (select count(*) from table_three) + (select count(*) from table_four) + (select count(*) from table_five) as total_rows from table_one limit 1
Re: Descriptive Subjects
Posted: Mon Nov 05, 2007 4:38 am
by aaronhall
scepanmali wrote:feyd wrote:If this is throwing you into a fit, I'd stop now.
OK, if you don't want to help me, don't talk with me and go to another place!
Stay out of my thread! I am a beginner, so if you have problem with that, almighty YOU, go away and let other GOOD people to help! Good bye!
Rule #1 of the internet: never pick fights with forum moderators
Rule #2 of the internet: never break forum rules and get offended when someone points the offense out, lest you make a complete jackass of yourself
Re: Descriptive Subjects
Posted: Mon Nov 05, 2007 9:58 am
by Kieran Huggins
aaronhall wrote:I love lamp (but I have something going on with Python on the side).
That
HUSSY!
Posted: Mon Nov 05, 2007 7:23 pm
by aaronhall

she's been around