[請益] 關於show databases
我想要寫一個php程式
將mysql中有那些資料庫show出來
最後再加上新建資料表 輸入資料等等功能
但是在show資料庫這個步驟的時候
在網路上找了個人家寫的例子
$dbquery = mysqli_query($dbh,"SHOW DATABASES");
$i = 0;
while ($row = mysqli_fetch_assoc($dbquery)) {
$arr[$i] = $row['Database'];
echo "<br> ". $i ." = " .$arr[$i];
$i++;
}
最後show出來的畫面為
0 = information_schema
1 = 123
2 = TEST2
3 = mysql
4 = performance_schema
5 = test
基本上我資料庫內目前只有手動創建 '123' 'TEST2' 'test'
這三個而已
所以想請問一下 information_schema、mysql、performance_schema
抓到這三個值的意義
謝謝!
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 114.33.35.239
→
05/15 05:26, , 1F
05/15 05:26, 1F
→
05/15 12:51, , 2F
05/15 12:51, 2F
→
05/15 12:52, , 3F
05/15 12:52, 3F
→
05/15 13:03, , 4F
05/15 13:03, 4F
→
05/15 13:04, , 5F
05/15 13:04, 5F
→
05/15 13:05, , 6F
05/15 13:05, 6F
→
05/15 13:05, , 7F
05/15 13:05, 7F
→
05/15 13:44, , 8F
05/15 13:44, 8F
→
05/15 13:44, , 9F
05/15 13:44, 9F
→
05/15 13:45, , 10F
05/15 13:45, 10F
→
05/15 13:50, , 11F
05/15 13:50, 11F
→
05/15 13:51, , 12F
05/15 13:51, 12F
→
05/15 13:56, , 13F
05/15 13:56, 13F
→
05/15 15:05, , 14F
05/15 15:05, 14F
→
05/15 15:32, , 15F
05/15 15:32, 15F
→
05/15 15:33, , 16F
05/15 15:33, 16F
→
05/15 15:34, , 17F
05/15 15:34, 17F
→
05/15 15:34, , 18F
05/15 15:34, 18F
→
05/15 15:36, , 19F
05/15 15:36, 19F
→
05/15 16:21, , 20F
05/15 16:21, 20F
→
05/16 12:30, , 21F
05/16 12:30, 21F
→
05/16 12:31, , 22F
05/16 12:31, 22F
→
05/16 12:34, , 23F
05/16 12:34, 23F
→
05/16 12:34, , 24F
05/16 12:34, 24F
→
05/16 14:00, , 25F
05/16 14:00, 25F
PHP 近期熱門文章
PTT數位生活區 即時熱門文章
