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 :madblow:

Descriptive Subjects

Posted: Sun Nov 04, 2007 7:24 am
by feyd
If this is throwing you into a fit, I'd stop now.
[url=http://forums.devnetwork.net/viewtopic.php?t=30037]Forum Rules[/url] Section 1.1 wrote:2. Use descriptive subjects when you start a new thread. Vague titles such as "Help!", "Why?" are misleading and keep you from receiving an answer to your question.

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.
[url=http://forums.devnetwork.net/viewtopic.php?t=30037]Forum Rules[/url] Section 1.1 wrote:2. Use descriptive subjects when you start a new thread. Vague titles such as "Help!", "Why?" are misleading and keep you from receiving an answer to your question.
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.
[url=http://forums.devnetwork.net/viewtopic.php?t=30037]Forum Rules[/url] Section 1.1 wrote:2. Use descriptive subjects when you start a new thread. Vague titles such as "Help!", "Why?" are misleading and keep you from receiving an answer to your question.
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).
:rofl:

That HUSSY!

Posted: Mon Nov 05, 2007 7:23 pm
by aaronhall
:lol: she's been around