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 `wh_lms_migrations` ORDER BY `batch` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
id migration batch Descending Ascending 1
170 2020_03_12_091035_create_jobs_table 16
169 2018_12_10_102727_create_lead_dead_reasons_table 15
168 2018_12_08_105920_create_sales_table 14
167 2018_12_04_131846_create_regions_table 13
166 2018_11_29_161442_create_lead_documents_table 12
165 2018_11_20_095612_create_company_permissions_role_... 11
164 2018_11_20_094753_create_company_permissions_table 10
163 2018_11_19_113358_create_employee_designations_tab... 9
162 2018_11_16_120435_creat_leads_assigned_table 8
161 2018_10_18_150455_add_engage_status_to_users_table 7
160 2018_10_17_174921_create_team_members_table 6
156 2018_10_11_094345_add_country_id_foreignkey_in_use... 5
155 2018_10_24_270227_create_leadtype_table 4
154 2018_07_13_270227_create_leads_table 3
153 2018_10_24_270227_create_leads_history_table 2
143 2017_04_13_200254_create_api_tokens_table 1
152 2018_10_24_270227_create_servicestatus_table 1
136 2015_09_19_191655_setup_countries_table 1
138 2015_10_10_171049_create_social_login_table 1
139 2015_12_24_080704_setup_authorization_tables 1
148 2018_10_24_270227_create_leadsource_table 1
140 2015_12_24_152327_create_sessions_table 1
146 2018_10_24_270227_create_departments_table 1
145 2018_10_24_270227_create_company_table 1
144 2018_10_24_270227_create_callstatus_table 1
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