Drop files here

SQL upload ( 0 ) x -

Page-related settings Click 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 :
Browse mode
Customize browse mode.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `z_mobile_teacher_permission_master`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts perm_master_id module_key module_name action_key action_name sort_order is_active delete_status
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 1
1 students Students view View Students 1 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 2
2 attendance Attendance view View Attendance 10 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 3
3 attendance Attendance create Mark Attendance 11 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 4
4 attendance Attendance update Update Attendance 12 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 5
5 homework Homework view View Homework 20 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 6
6 homework Homework create Create Homework 21 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 7
7 homework Homework update Update Homework 22 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 8
8 homework Homework delete Delete Homework 23 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 9
9 notification Notification view View Notifications 30 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 10
10 notification Notification create Create Notification 31 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 11
11 notification Notification publish Publish Notification 32 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 12
12 notification Notification delete Delete Notification 33 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 13
13 marks Marks Entry view View Marks 40 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 14
14 marks Marks Entry create Enter Marks 41 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 15
15 marks Marks Entry update Update Marks 42 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 16
16 study_material Study Material view View Study Material 50 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 17
17 study_material Study Material create Upload Study Material 51 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 18
18 study_material Study Material delete Delete Study Material 52 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 19
19 timetable Timetable view View Timetable 60 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 20
20 events Events view View Events 70 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 21
21 events Events create Create Events 71 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 22
22 parent_chat Parent Chat view View Parent Chat 80 1 0
Edit Edit Copy Copy Delete Delete
DELETE FROM z_mobile_teacher_permission_master WHERE `z_mobile_teacher_permission_master`.`perm_master_id` = 23
23 parent_chat Parent Chat send Send Message 81 1 0
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query