乱爱性全过程免费视频/午夜毛片视频/中文字幕av三区/一级视频网址

當(dāng)前位置： 維易PHP培訓(xùn)學(xué)院 > MYSQL教程 > 內(nèi)容正文

Mysql學(xué)習(xí)mysql統(tǒng)計多表交叉組合總數(shù)實例

作者：VEPHP   時間 2017-09-27

《Mysql學(xué)習(xí)mysql統(tǒng)計多表交叉組合總數(shù)實例》要點：
本文介紹了Mysql學(xué)習(xí)mysql統(tǒng)計多表交叉組合總數(shù)實例，希望對您有用。如果有疑問，可以聯(lián)系我們。

導(dǎo)讀：例子,mysql如何統(tǒng)計多表交叉組合總數(shù). >mysql -h localhost -u root -pmysql> use world; Database changed mysql> show tabl...

MYSQL實例例子,mysql如何統(tǒng)計多表交叉組合總數(shù).
?

MYSQL實例>mysql -h localhost -u root -p?

MYSQL實例mysql> use world;?
Database changed?
mysql> show tables;?
+-----------------+?
| Tables_in_world |?
+-----------------+?
| city??????????? |?
| country???????? |?
| countrylanguage |?
+-----------------+?
3 rows in set (0.00 sec)?

MYSQL實例mysql> select count(*) from city;?
+----------+?
| count(*) |?
+----------+?
|???? 4079 |?
+----------+?
1 row in set (0.00 sec)?

MYSQL實例mysql> select count(*) from country;?
+----------+?
| count(*) |?
+----------+?
|????? 239 |?
+----------+?
1 row in set (0.00 sec)?

MYSQL實例mysql> select 4079*239?
??? -> ;?
+----------+?
| 4079*239 |?
+----------+?
|?? 974881 |?
+----------+?
1 row in set (0.00 sec)?

MYSQL實例這里就是計算交叉組合數(shù)量,因為他們之間一個相同的關(guān)聯(lián)字段
?

mysql> select count(*) from city,country?
??? -> ;?
+----------+?
| count(*) |?
+----------+?
|?? 974881 |?
+----------+?
1 row in set (0.00 sec)?

MYSQL實例實際上mysql所做的操作就是把你所查詢表的數(shù)量相乘得到的結(jié)果!
?

mysql> select count(*) from city,country,countrylanguage;?
+-----------+?
| count(*)? |?
+-----------+?
| 959282904 |?
+-----------+?
1 row in set (0.02 sec)?
?
mysql> select count(*) from countrylanguage;?
+----------+?
| count(*) |?
+----------+?
|????? 984 |?
+----------+?
1 row in set (0.00 sec)?
?
mysql> select 4079*239*984;?
+--------------+?
| 4079*239*984 |?
+--------------+?
|??? 959282904 |?
+--------------+?
1 row in set (0.00 sec)

轉(zhuǎn)載請注明本頁網(wǎng)址：
http://www.fzlkiss.com/jiaocheng/6183.html


    標(biāo)簽：