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 `temp_db` ORDER BY `approver_id` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id table_id dravya_id table_name reference_id ref_remarks status created_at created_by updated_at updated_by data_entry_worker_id approver_id Descending Ascending 1 comments display_order
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16485
16485 48 57 pharmacopoeial_status_m NULL NULL ACTIVE 2025-11-24 12:13:28 2 2025-11-25 10:19:44 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16484
16484 12 57 dose_m NULL NULL ACTIVE 2025-11-24 12:11:11 2 2025-11-25 10:19:44 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16483
16483 17 57 dose_m NULL NULL ACTIVE 2025-11-24 12:11:11 2 2025-11-25 10:19:44 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16482
16482 1182 57 therapeutic_usage_m NULL NULL ACTIVE 2025-11-24 12:09:33 2 2025-11-25 10:19:44 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16481
16481 3228 57 therapeutic_usage_m NULL NULL ACTIVE 2025-11-24 12:09:33 2 2025-11-25 10:19:44 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16480
16480 3199 57 therapeutic_usage_m NULL NULL ACTIVE 2025-11-24 12:09:33 2 2025-11-25 10:19:44 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16479
16479 3213 57 therapeutic_usage_m NULL NULL ACTIVE 2025-11-24 12:09:33 2 2025-11-25 10:19:44 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16478
16478 3206 57 therapeutic_usage_m NULL NULL ACTIVE 2025-11-24 12:09:33 2 2025-11-25 10:19:44 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16471
16471 18 57 doshakarma_m NULL NULL ACTIVE 2025-11-24 11:26:34 2 2025-11-25 10:19:44 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16457
16457 15 57 part_used_m NULL NULL ACTIVE 2025-11-24 10:59:24 2 2025-11-25 10:19:44 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16456
16456 16 57 part_used_m NULL NULL ACTIVE 2025-11-24 10:59:24 2 2025-11-25 10:19:44 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16455
16455 15 57 family_name_m NULL NULL ACTIVE 2025-11-24 10:57:36 2 2025-11-25 10:19:44 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16435
16435 3212 144 therapeutic_usage_m NULL NULL ACTIVE 2025-11-21 15:27:17 2 2025-11-25 12:04:42 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16434
16434 893 144 therapeutic_usage_m NULL NULL ACTIVE 2025-11-21 15:27:17 2 2025-11-25 12:04:42 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16433
16433 3213 144 therapeutic_usage_m NULL NULL ACTIVE 2025-11-21 15:27:17 2 2025-11-25 12:04:42 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16432
16432 784 144 therapeutic_usage_m NULL NULL ACTIVE 2025-11-21 15:27:17 2 2025-11-25 12:04:42 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16431
16431 617 144 therapeutic_usage_m NULL NULL ACTIVE 2025-11-21 15:27:17 2 2025-11-25 12:04:42 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16430
16430 918 144 therapeutic_usage_m NULL NULL ACTIVE 2025-11-21 15:27:17 2 2025-11-25 12:04:42 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16429
16429 636 144 therapeutic_usage_m NULL NULL ACTIVE 2025-11-21 15:27:17 2 2025-11-25 12:04:42 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16428
16428 3197 144 therapeutic_usage_m NULL NULL ACTIVE 2025-11-21 15:27:17 2 2025-11-25 12:04:42 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16427
16427 3206 144 therapeutic_usage_m NULL NULL ACTIVE 2025-11-21 15:27:17 2 2025-11-25 12:04:42 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16395
16395 46 159 pharmacopoeial_status_m NULL NULL ACTIVE 2025-11-20 17:29:34 2 2025-11-25 10:26:18 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16394
16394 21 159 dose_m NULL NULL ACTIVE 2025-11-20 17:21:04 2 2025-11-25 10:26:18 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16393
16393 1388 159 therapeutic_usage_m NULL NULL ACTIVE 2025-11-20 17:15:16 2 2025-11-25 10:26:18 3 2 3 NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM temp_db WHERE `temp_db`.`id` = 16392
16392 3223 159 therapeutic_usage_m NULL NULL ACTIVE 2025-11-20 17:15:16 2 2025-11-25 10:26:18 3 2 3 NULL 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