Atitit database table Document generation solution

Atitit database Table document generation solution

1.1. Sql DML file structure method fastest 1

1.2. Sql method +sp stored procedure (table style)1

1.3. navicate UML method (UML format)2

1.4. H5 chart method (visual good looking and practical combination)2

1.5. Meta API method 3

1.6. gets which tables the table list database contains. View, etc... 3

1.1. Sql DML File structure method is the fastest

CREATE TABLE ' L_laundry ' (

' id ' int (one) unsigned not NULL auto_increment,

' title ' varchar (255) COLLATE utf8_bin DEFAULT NULL COMMENT ' laundry room name ',

' Name ' varchar (255) CHARACTER SET UTF8 DEFAULT NULL COMMENT ' owner name ',

' Phone ' varchar CHARACTER SET UTF8 DEFAULT NULL COMMENT ' phone number ',

' Delete_flag ' varchar (6) COLLATE utf8_bin DEFAULT ' 1 ' COMMENT ' delete tag 1 enabled , 2 Delete ',

' creator_id ' varchar COLLATE utf8_bin DEFAULT NULL COMMENT ' creator ',

' Creator_time ' datetime DEFAULT NULL COMMENT ' creation time ',

' update_id ' varchar COLLATE utf8_bin DEFAULT NULL COMMENT ' modifier ',

' Update_time ' datetime DEFAULT NULL COMMENT ' modified time ',

PRIMARY KEY (' id ')

) Engine=innodb auto_increment=4 DEFAULT Charset=utf8 collate=utf8_bin;

1.2. Sql method +sp stored procedure (table style)

SQL is used to query a single table,theSP is used to loop multiple tables, generally a library of more than one table.

SELECT

Table_schema Database ,

TABLE_NAME table name ,

column_name Column name ,

Is_nullable,

Data_type Data type ,

Column_type field type ,

Column_key primary Key ,

Column_comment Comment meaning

From

Information_schema. COLUMNS

WHERE

table_name = ' S_member '

ORDER by

Table_schema,

table_name

1.3. navicate UML method (UML format)

The advantage is good-looking, the disadvantage is that there are comments

1.4. H5 Chart Method (visual good-looking and practical combination)

involves a certain development.

1.5. Meta API method

1.6. gets which tables are contained in the table list database. View, etc...

SELECT * FROM INFORMATION_SCHEMA. TABLES where table_schema= ' laundry '

Select Table_schema Database , table_name table name , table_type type , table_comment Note from information_schema. TABLES where table_schema= ' laundry '

author :: Nickname: Old Wow's paw claw of Eagle idol iconoclast Image-smasher

Bird King "Bird Catcher Kok devout pious religious defender Defender of the Faith. Caracalla red cloak Caracalla red cloak king of beasts

abbreviation:: Emir Attilax Akbar Emile Atiraca

Full Name:: Emir Attilax Akbar bin Mahmud bin Attila bin Solomon bin Adam Al Rapanui Emile Atilax Akbaben Maham Solomon Ben Adam Arrapanui

Common name: Etila (Ayron), Email:[email protected]

title:Head of Uke headquarters, founder of Global Grid project,

Uke Friendship Association president Uke Hunting Association president Emir Uke Tribe chief Grand Chief,

Uke, Minister of Religious and Cultural Integration Affairs, Vice-Chairman of the Uke Reformation Commission

Uke system and chairman of the major conference committee, Uke Security Department Chief Brigade, Uke System Inspection Committee vice President,

UKE Chief CTO Software Division Director of Technical department deputy Director of Research and Development department Director of Product department deputy Manager Project department deputy Manager Uke Science and Technology research Institute Dean Uke Software Training Master

Uke Polynesia District chain Head of the area responsible for the Kingdom of Tonga Uke Kerr Glen, chain head, Line Is. district chain head, Uke Bouvet and South Georgia and South Sandwich Is. region chain Head

Uke, chairman of the Association of Software Standardization, vice president of Uke Database and storage Standardization Association

Uke, founder of Uke Hospital and Medical school, vice president of lifelong Education School

UEC, president of UECIP, director of UKE document Retrieval department, head of Department of image processing machine vision

Uke, chief Dean of the School of image processing and machine vision

Uke Outdoor Sports Association chairman of the resort chief Mayor Uke Press editor

reprint Please indicate source:Attilax's column? http://www.cnblogs.com/attilax/

--atiend V8

Atitit database table Document generation solution