شمارش سطرهای چند جدول

[Yousha]

2 تا راه دارید:
با سرعت بیشتر:


select (select count(i) from Table1) as CountTable1, (select count(i) from Table2) as CountTable2;

0.0119230747223
0.0121021270752
0.0121040344238
0.0123291015625
0.0123801231384
0.0124671459198
0.0125391483307
0.0140120983124
0.0141270160675
0.0141861438751


با سرعت کمتر و امکان distinct کردن فیلد(مثل فیلتر کردن مقدار تکراری):


select count(distinct Table1.i) as CountTable1, count(distinct Table2.i) as CountTable2 from Table1, Table2;

0.0124239921570
0.0124990940094
0.0128171443939
0.0128891468048
0.0128941535950
0.0130000114441
0.0132040977478
0.0148260593414
0.0150711536407


count rows multi table, count rows mysql, sql

منبع: http://forum.iranphp.org