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 `ledger_shipping_details`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id ledger_id ledger_cash_id parent_led_id
entry_id
voucher_type_id is_primary ship_to mailing_name shipping_address shipping_contact shipping_city shipping_state_id shipping_country_id shipping_pincode shipping_gstin place_of_supply delivery_source godown_id plant_id branch_id created_at updated_at
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 1
1 11 0 1 2 N Abhi Abhi Karnataka 577201, India NULL NULL 11 1 577201 GODOWN 5 0 1 2025-10-29 10:45:21 2025-10-29 15:15:48
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 2
2 11 0 2 4 N Abhi Abhi Karnataka 577201, India 11 1 577201 GODOWN 5 0 1 2025-10-29 16:11:15 2025-10-29 16:59:59
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 3
3 11 0 2 4 N Abhi Abhi Karnataka 577201, India 11 1 577201 GODOWN 5 0 1 2025-10-29 16:12:54 2025-10-29 16:59:59
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 4
4 11 0 2 4 N Abhi Abhi Karnataka 577201, India 11 1 577201 GODOWN 5 0 1 2025-10-29 16:13:12 2025-10-29 16:59:59
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 5
5 11 0 2 4 N Abhi Abhi Karnataka 577201, India 11 1 577201 GODOWN 5 0 1 2025-10-29 16:16:17 2025-10-29 16:59:59
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 6
6 11 0 2 4 N Abhi Abhi Karnataka 577201, India 11 1 577201 GODOWN 5 0 1 2025-10-29 16:16:44 2025-10-29 16:59:59
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 7
7 253 1 3 4 N Cash Cash NULL NULL 11 1 GODOWN 5 0 1 2025-10-29 14:03:43 2025-10-29 18:33:43
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 8
8 253 2 4 4 N Cash Cash NULL NULL 11 1 GODOWN 5 0 1 2025-10-29 14:08:53 2025-10-29 18:38:53
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 9
9 253 3 5 4 N Cash Cash NULL NULL 11 1 GODOWN 5 0 1 2025-10-29 14:10:32 2025-10-29 14:13:20
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 10
10 140 0 6 1 N A.S.Rangappa And Sons A.S.Rangappa And Sons NULL NULL 11 1 GODOWN 5 0 1 2025-10-30 06:05:07 2025-10-30 10:35:41
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 11
11 657 0 7 2 N Isiri Innovative Products Private Limited Isiri Innovative Products Private Limited Karnataka 577201, India NULL NULL 11 1 577201 GODOWN 6 0 1 2025-10-30 06:13:55 2025-10-30 10:48:54
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 12
12 0 0 8 1 N Isiri Innovative Products Private Limited Isiri Innovative Products Private Limited Karnataka 577201, India NULL NULL 11 1 577201 GODOWN 6 0 1 2025-10-30 10:57:40 2025-10-30 11:01:14
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 13
13 253 4 9 2 N Cash Cash Karnataka 577201, India NULL NULL 11 1 577201 GODOWN 36 0 1 2025-10-30 06:34:47 2025-10-30 11:14:55
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 21
21 253 4 10 1 N Cash Cash Karnataka 577201, India 11 1 577201 GODOWN 36 0 1 2025-10-30 11:28:13 2025-10-30 11:29:25
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 22
22 8 0 11 1 N Abdul Wajeed (Lorry Frieght) Abdul Wajeed (Lorry Frieght) NULL NULL 11 1 GODOWN 9 0 1 2025-10-30 07:03:52 2025-10-30 11:47:52
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 23
23 32 0 12 2 N A G Mohan A G Mohan NULL NULL 11 1 GODOWN 57 0 1 2025-10-30 07:07:04 2025-10-30 11:37:16
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 24
24 253 7 13 3 N Cash Fgdfgdfg Karnataka 577201, India NULL NULL 11 1 577201 GODOWN 47 0 1 2025-10-30 07:18:40 2025-10-30 11:49:37
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 25
25 253 7 14 1 N Cash Fgdfgdfg Karnataka 577201, India NULL NULL 11 1 577201 GODOWN 47 0 1 2025-10-30 11:50:08 2025-10-30 11:50:08
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 26
26 2104 0 15 1 N Sri Vinayaka Traders Sri Vinayaka Traders NULL NULL 11 1 GODOWN 6 0 1 2025-10-30 08:23:41 2025-10-30 13:05:53
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 27
27 2104 0 16 4 N Sri Vinayaka Traders Sri Vinayaka Traders NULL NULL 11 1 GODOWN 56 0 1 2025-10-30 08:37:52 2025-10-30 13:07:52
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 28
28 253 9 17 4 N Cash Cash Karnataka 577201, India NULL NULL 11 1 577201 GODOWN 5 0 1 2025-10-30 08:45:17 2025-10-30 13:15:17
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 29
29 253 10 1 5 N Dsfsdf Dsfsdf Karnataka 577201, India NULL NULL 11 1 577201 GODOWN 58 0 1 2025-10-30 09:21:01 2025-10-30 13:51:01
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 30
30 108 0 2 5 N Arihant Steels Arihant Steels Karnataka 577201, India NULL NULL 11 1 577201 GODOWN 50 0 1 2025-10-30 09:22:19 2025-10-30 13:52:19
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 31
31 253 11 18 4 N Cash Cash Anavatti, Karnataka 577413, India NULL NULL 11 1 577413 GODOWN 5 0 1 2025-10-30 11:24:00 2025-10-30 15:54:00
Edit Edit Copy Copy Delete Delete
DELETE FROM ledger_shipping_details WHERE `ledger_shipping_details`.`id` = 32
32 105 0 19 2 N A R Hardwares A R Hardwares NULL NULL 11 1 GODOWN 8 0 1 2025-10-30 13:05:59 2025-10-30 17:36:31
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