dos下连接mysql,显示表结构
时间:2022-03-13 23:33
C:\Windows\system32>mysql -hlocalhoset -uroot -p Enter password: ***** mysql> use ssh Database changed mysql> show tables; +----------------+ | Tables_in_ssh | +----------------+ | admin | | department | | privilege | | privilege_role | | role | | user_role | +----------------+ 6 rows in set (0.00 sec)
//显示表结构 1)mysql> desc admin; +---------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +---------------+--------------+------+-----+---------+-------+ | id | varchar(255) | NO | PRI | NULL | | | name | varchar(255) | YES | | NULL | | | account | varchar(255) | YES | | NULL | | | password | varchar(255) | YES | | NULL | | | addTime | datetime | YES | | NULL | | | delSign | varchar(255) | YES | | NULL | | | lockStatus | varchar(255) | YES | | NULL | | | phone | varchar(255) | YES | | NULL | | | email | varchar(255) | YES | | NULL | | | nowLoginTime | datetime | YES | | NULL | | | nowLoginIp | varchar(255) | YES | | NULL | | | lastLoginTime | datetime | YES | | NULL | | | lastLoginIp | varchar(255) | YES | | NULL | | | loginCount | int(11) | YES | | NULL | | | description | varchar(255) | YES | | NULL | | | gender | varchar(255) | YES | | NULL | | | birthday | datetime | YES | | NULL | | | icon | varchar(255) | YES | | NULL | | | qq | varchar(255) | YES | | NULL | | | address | text | YES | | NULL | | | departmentId | varchar(255) | YES | MUL | NULL | | +---------------+--------------+------+-----+---------+-------+
2)mysql> show create table admin; ------------------------------------+ | admin | CREATE TABLE `admin` ( `id` varchar(255) NOT NULL, `name` varchar(255) DEFAULT NULL, `account` varchar(255) DEFAULT NULL, `password` varchar(255) DEFAULT NULL, `addTime` datetime DEFAULT NULL, `delSign` varchar(255) DEFAULT NULL, `lockStatus` varchar(255) DEFAULT NULL, `phone` varchar(255) DEFAULT NULL, `email` varchar(255) DEFAULT NULL, `nowLoginTime` datetime DEFAULT NULL, `nowLoginIp` varchar(255) DEFAULT NULL, `lastLoginTime` datetime DEFAULT NULL, `lastLoginIp` varchar(255) DEFAULT NULL, `loginCount` int(11) DEFAULT NULL, `description` varchar(255) DEFAULT NULL, `gender` varchar(255) DEFAULT NULL, `birthday` datetime DEFAULT NULL, `icon` varchar(255) DEFAULT NULL, `qq` varchar(255) DEFAULT NULL, `address` text, `departmentId` varchar(255) DEFAULT NULL, PRIMARY KEY (`id`), KEY `FK586034F91261A86` (`departmentId`), CONSTRAINT `FK586034F91261A86` FOREIGN KEY (`departmentId`) REFERENCES `department` (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 | +-------+--------------------------------------------------------------------------------------
3)show columns from admin;
4)describe admin;