Difference between revisions of "Mysql"

From SPGC Document Wiki
Jump to: navigation, search
Line 223: Line 223:
 
|No
 
|No
 
|Yes
 
|Yes
 +
|No
 +
|}
 +
 +
==event==
 +
{| class="wikitable" \
 +
!colspan="7" | event
 +
|-
 +
! style="text-align:left;" | Column Name
 +
! Data Type
 +
! Length
 +
! Is PrimaryKey
 +
! Is Not Null
 +
! Auto Increment
 +
|-
 +
|db
 +
|char
 +
|64
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|name
 +
|char
 +
|64
 +
|Yes
 +
|Yes
 +
|No
 +
|-
 +
|body
 +
|longblob
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|definer
 +
|char
 +
|77
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|execute_at
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|interval_value
 +
|int
 +
|11
 +
|No
 +
|No
 +
|No
 +
|-
 +
|interval_field
 +
|0
 +
|64
 +
|No
 +
|No
 +
|No
 +
|-
 +
|created
 +
|timestamp
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|modified
 +
|timestamp
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|last_executed
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|starts
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|ends
 +
|datetime
 +
|0
 +
|No
 +
|No
 +
|No
 +
|-
 +
|status
 +
|enum
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|on_completion
 +
|enum
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|sql_mode
 +
|set
 +
|0
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|comment
 +
|char
 +
|64
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|originator
 +
|int
 +
|10
 +
|No
 +
|Yes
 +
|Yes
 +
|-
 +
|time_zone
 +
|char
 +
|64
 +
|No
 +
|Yes
 +
|No
 +
|-
 +
|character_set_client
 +
|char
 +
|32
 +
|No
 +
|No
 +
|No
 +
|-
 +
|collation_connection
 +
|char
 +
|32
 +
|No
 +
|No
 +
|No
 +
|-
 +
|db_collation
 +
|char
 +
|32
 +
|No
 +
|No
 +
|No
 +
|-
 +
|body_utf8
 +
|longblob
 +
|0
 +
|No
 +
|No
 
|No
 
|No
 
|}
 
|}

Revision as of 08:57, 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

event

event
Column Name Data Type Length Is PrimaryKey Is Not Null Auto Increment
db char 64 Yes Yes No
name char 64 Yes Yes No
body longblob 0 No Yes No
definer char 77 No Yes No
execute_at datetime 0 No No No
interval_value int 11 No No No
interval_field 0 64 No No No
created timestamp 0 No Yes No
modified timestamp 0 No Yes No
last_executed datetime 0 No No No
starts datetime 0 No No No
ends datetime 0 No No No
status enum 0 No Yes No
on_completion enum 0 No Yes No
sql_mode set 0 No Yes No
comment char 64 No Yes No
originator int 10 No Yes Yes
time_zone char 64 No Yes No
character_set_client char 32 No No No
collation_connection char 32 No No No
db_collation char 32 No No No
body_utf8 longblob 0 No No No
Retrieved from "http://115.85.30.86:286/spgcwiki/index.php?title=Mysql&oldid=2691"