Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: punjab_iot »Table: activity_log
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count : Time taken :
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





Collapse Expand Requery Edit Explain Profiling Bookmark Query failed Database : Queried time :

Table structure

Settings for the table structure (list of columns).

Documentation Whether the table structure actions should be hidden.
Documentation Whether column comments should be shown in table structure view
# Name Type Collation Attributes Null Default Comments Extra Action
1 int(10) UNSIGNED No None AUTO_INCREMENT Change Change Drop Drop
2 varchar(191) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
3 text utf8mb4_unicode_ci No None Change Change Drop Drop
4 int(11) Yes NULL Change Change Drop Drop
5 varchar(191) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
6 int(11) Yes NULL Change Change Drop Drop
7 varchar(191) utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
8 text utf8mb4_unicode_ci Yes NULL Change Change Drop Drop
9 timestamp Yes NULL Change Change Drop Drop
10 timestamp Yes NULL Change Change Drop Drop
With selected: With selected:

Add column  Add column(s)  
IndexesDocumentation
No index defined!
ActionKeynameTypeUniquePackedColumnCardinalityCollationNullComment
Edit Edit Drop Drop PRIMARYBTREEYesNoid6ANo
Edit Edit Drop Drop activity_log_log_name_indexBTREENoNolog_name2AYes
Create an index on   columns
PartitionsDocumentation
No partitioning defined!
Information
Space usage
Data 16 KiB
Index 16 KiB
Total 32 KiB
Row statistics
Format Compact
Collation utf8mb4_unicode_ci
Next autoindex 7
Creation Sep 29, 2019 at 10:43 PM