Collection
Collection
一、数据库版本信息的获取方法有多种
1、使用SQL查询的方式获取：selcet version();
2、mysqli_get_server_info($link);/mysqli_get_server_version($link);
二、获取数据库大小
原理：SHOW TABLE STATUS FROM “数据库名"
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
array(1) {
[0] => array(18) {
["Name"] => string(10) "bb_manager"
["Engine"] => string(6) "MyISAM"
["Version"] => int(10)
["Row_format"] => string(7) "Dynamic"
["Rows"] => int(1)
["Avg_row_length"] => int(52)
["Data_length"] => int(52)
["Max_data_length"] => string(15) "281474976710655"
["Index_length"] => int(2048)
["Data_free"] => int(0)
["Auto_increment"] => int(2)
["Create_time"] => string(19) "2017-08-06 11:59:07"
["Update_time"] => string(19) "2017-08-09 16:44:25"
["Check_time"] => NULL
["Collation"] => string(15) "utf8_general_ci"
["Checksum"] => NULL
["Create_options"] => string(0) ""
["Comment"] => string(9) "管理员"
}
}