1.展示所有的表
SHOW TABLES
$tableList[reset($row)] = reset($row);
array(5) {
[0] => array(1) {
["Tables_in_test"] => string(12) "employee_tbl"
}
[1] => array(1) {
["Tables_in_test"] => string(9) "lo_school"
}
[2] => array(1) {
["Tables_in_test"] => string(22) "yp_game_sensitive_font"
}
[3] => array(1) {
["Tables_in_test"] => string(16) "yp_live_chat_say"
}
[4] => array(1) {
["Tables_in_test"] => string(25) "yp_live_user_login_number"
}
}
2.查询表结构
show create table yp_live_user_login_number
array(1) {
[0] => array(2) {
["Table"] => string(25) "yp_live_user_login_number"
["Create Table"] => string(510) "CREATE TABLE `yp_live_user_login_number` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`live_number` varchar(100) NOT NULL DEFAULT '0' COMMENT '直播编号',
`user_id` int(11) NOT NULL DEFAULT '0' COMMENT '用户user_id',
`type` tinyint(1) DEFAULT '1' COMMENT '1:普通用户 ,2:主播',
`create_time` int(11) DEFAULT '0' COMMENT '创建时间',
`update_time` int(11) DEFAULT '0' COMMENT '更新时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='记录用户登录信息'"
}
}