Difference between revisions of "Mysql"

From SPGC Document Wiki
Jump to: navigation, search
(Created page with "==columns_priv== {| class="wikitable" \ !colspan="7" | columns_priv |- ! style="text-align:left;" | Column Name ! Data Type ! Length ! Is PrimaryKey ! Is Not Null ! Auto Incre...")
 
Line 55: Line 55:
 
|set
 
|set
 
|0
 
|0
 +
|No
 +
|Yes
 +
|No
 +
|}
 +
 +
==db==
 +
{| class="wikitable" \
 +
!colspan="7" | db
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|Host
 +
|char
 +
|60
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|Db
 +
|char
 +
|64
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|User
 +
|char
 +
|16
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|Select_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Insert_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Update_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Delete_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Create_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Drop_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Grant_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|References_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Index_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Alter_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Create_tmp_table_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Lock_tables_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Create_view_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Show_view_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Create_routine_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Alter_routine_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Execute_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Event_priv
 +
|enum
 +
|N,Y
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|Trigger_priv
 +
|enum
 +
|N,Y
 
|No
 
|No
 
|Yes
 
|Yes
 
|No
 
|No
 
|}
 
|}

Revision as of 08:44, 9 August 2016

columns_priv

columns_priv
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Host char 60 Yes Yes No
Db char 64 Yes Yes No
User char 16 Yes Yes No
Table_name char 64 Yes Yes No
Column_name char 64 Yes Yes No
Timestamp timestamp 0 No Yes No
Column_priv set 0 No Yes No

db

db
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
Host char 60 Yes Yes No
Db char 64 Yes Yes No
User char 16 Yes Yes No
Select_priv enum N,Y No Yes No
Insert_priv enum N,Y No Yes No
Update_priv enum N,Y No Yes No
Delete_priv enum N,Y No Yes No
Create_priv enum N,Y No Yes No
Drop_priv enum N,Y No Yes No
Grant_priv enum N,Y No Yes No
References_priv enum N,Y No Yes No
Index_priv enum N,Y No Yes No
Alter_priv enum N,Y No Yes No
Create_tmp_table_priv enum N,Y No Yes No
Lock_tables_priv enum N,Y No Yes No
Create_view_priv enum N,Y No Yes No
Show_view_priv enum N,Y No Yes No
Create_routine_priv enum N,Y No Yes No
Alter_routine_priv enum N,Y No Yes No
Execute_priv enum N,Y No Yes No
Event_priv enum N,Y No Yes No
Trigger_priv enum N,Y No Yes No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Mysql&oldid=2685"