Connect MySQL under DOS, show table structure

C:\windows\system32>mysql-hlocalhoset-uroot-pEnter Password: *****mysql>Use sshDatabase changedmysql>show tables;+----------------+| Tables_in_ssh |+----------------+| admin | | Department | | Privilege | | Privilege_role | | Role | | User_role |+----------------+6 rows in Set (0.00 sec)

Show Table structure 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 NUL L, ' password ' varchar (255) default NULL, ' Addtime ' datetime default NULL, ' delsign ' varchar (255) default NULL, ' Lockst ATUs ' varchar (255) default NULL, ' phone ' varchar (255) default NULL, ' email ' varchar (255) default NULL, ' Nowlogintime ' d Atetime default NULL, ' Nowloginip ' varchar (255) default NULL, ' Lastlogintime ' datetime default NULL, ' Lastloginip ' Varc Har (255) default NULL, ' Logincount ' int (one) 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, ' A  Ddress ' 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;

Connect MySQL under DOS, show table structure