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
Customise 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 `mrbs_area` ORDER BY `min_create_ahead_secs` ASC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id disabled area_name sort_key timezone area_admin_email resolution default_duration default_duration_all_day morningstarts morningstarts_minutes eveningends eveningends_minutes private_enabled private_default private_mandatory private_override min_create_ahead_enabled min_create_ahead_secs Ascending Descending 1 max_create_ahead_enabled max_create_ahead_secs min_delete_ahead_enabled min_delete_ahead_secs max_delete_ahead_enabled max_delete_ahead_secs max_per_day_enabled max_per_day max_per_week_enabled max_per_week max_per_month_enabled max_per_month max_per_year_enabled max_per_year max_per_future_enabled max_per_future max_secs_per_day_enabled max_secs_per_day max_secs_per_week_enabled max_secs_per_week max_secs_per_month_enabled max_secs_per_month max_secs_per_year_enabled max_secs_per_year max_secs_per_future_enabled max_secs_per_future max_duration_enabled max_duration_secs max_duration_periods custom_html approval_enabled reminders_enabled enable_periods periods confirmation_enabled confirmed_default times_along_top default_type
Edit Edit Copy Copy Delete Delete
DELETE FROM mrbs_area WHERE `mrbs_area`.`id` = 1
1 0 UNIT PENGURUSAN MAKLUMAT UPM Asia/Kuching 1800 3600 1 7 0 17 30 0 0 0 none 0 0 0 604800 0 0 0 604800 0 1 0 5 0 10 0 50 0 100 0 7200 0 36000 0 90000 0 360000 0 360000 0 7200 2 NULL 0 1 0 {"Period 1":[null,null],"Period 2":[null,null]} 1 1 0 I
Edit Edit Copy Copy Delete Delete
DELETE FROM mrbs_area WHERE `mrbs_area`.`id` = 2
2 0 ARAS 3 ARAS 3 Asia/Kuala_Lumpur NULL 1800 3600 0 7 0 18 30 0 0 0 none 0 0 0 604800 0 0 0 604800 0 1 0 5 0 10 0 50 0 100 0 7200 0 36000 0 90000 0 360000 0 360000 0 7200 2 NULL 0 1 0 ["Period 1","Period 2"] 1 1 0 I
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