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 `purchase_orders` ORDER BY `size` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id order_date product_type item_name required_date product_code brand size Descending Ascending 1 remark quantity unit price_before_vat price_with_vat total_amount pr_number foreman job_number job_name vendor phone po_number ordered_by order_date_time expected_date received_date received_by invoice_no created_at updated_at
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 256
256 2023-03-29 ลามิเนต ลามิเนตสีเทา NULL WY7928NM FORMICA 4.00 แผ่น 980.00 1048.60 4194.40 PR6603201 ตั้ม 66-0316 WALL TV LG @ Lotus สาขาสุขาภิบาล 1 กทม. สันติ วู้ด โซน 6603-0475 แอ้ 2566-03-30 NULL 2566-03-31 อำนาจ IV6603321 2025-09-06 11:06:27 2025-09-06 11:06:27
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 512
512 2023-01-12 ไฟฟ้า หลอด LED ขั้ว GU5.3 6500 K. 2566-01-13 MR16 SL LIGHTING 4.00 หลอด 65.00 69.55 278.20 PR6601075 ตั้ม 65-0791 ARI DAIKIN @ พัทยานาเกลือ โชติธนา 6601-0164 แอ้ 2566-01-12 NULL 2566-01-12 ชัชวาลย์ PV2300250 2025-09-06 11:06:27 2025-09-06 11:06:27
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 768
768 2023-02-11 ไฟฟ้า สายไฟ VSF 1x1.5 สีดำ NULL THAI UNION 5.00 ม้วน 431.40 461.60 2307.99 PR6602075R.1 STOCK ปกรณ์ อิเล็คทริคอล 6602-0203 หญิง 2566-02-14 NULL 2566-02-16 รัศมี PVT66020110 2025-09-06 11:06:28 2025-09-06 11:06:28
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 1024
1024 2023-03-21 ไฟฟ้า สาย THW 1x4 เทา 2566-03-22 YAZAKI 1.00 ม้วน 1252.90 1340.60 1340.60 PR6603125 ถาวร 66-0213R.2 Cha Tra Mue @ YSS,SAMUTPRAKARN ประธานการไฟฟ้า 6603-0300 แอ้ 2566-03-21 NULL 2566-03-21 ประจักษ์/กรรณิกา IV6603-1575 2025-09-06 11:06:28 2025-09-06 11:06:28
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 1280
1280 2023-01-09 อะคริลิค อะคริลิค สีขาว หนา 2 มม. 4'x8' NULL 444 ของเข้าแล้ว 5.00 แผ่น 870.00 930.90 4654.50 PR6601059 มีน 65-1263 Stand Air Diakin (มีไฟ) 55 Set เอ.เอส.อุปกรณ์ป้าย 6601-0123 บิว 2566-01-09 NULL 2566-01-09 คมสัน IV-A-6601-055 2025-09-06 11:06:28 2025-09-06 11:06:28
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 1536
1536 2023-01-28 Fitting ขาปรับระดับสีดำ M8 2566-01-28 E014 186.00 ตัว 3.50 3.75 696.57 PR6601184 แก๊ป 66-0006 Brands Outlet @ Siam Premium Outlet South Sathorn IO ดีไซน์ 6601-0415 หญิง 2566-01-28 NULL 2566-01-28 เด่น IV660000602 2025-09-06 11:06:29 2025-09-06 11:06:29
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 1792
1792 2023-02-18 ไฟฟ้า เคเบิ้ลไทร์ สีดำ 12 นิ้ว NULL 1แพค:100เส้น 3.00 แพค 83.18 89.00 267.01 PR6602100_Rev.1 STOCK แสงใหม่ 6602-0281 แอ้ NULL NULL 2566-02-21 เด่นศักดิ์ / อรุณรัตน์ SS00123-001258 2025-09-06 11:06:29 2025-09-06 11:06:29
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 2048
2048 2023-03-17 กระเบื้อง กระเบื้องแกรนิตโต้ 2566-03-18 KCMT-06001M 1.44 ตรม 400.00 428.00 616.32 PR6603096 ถาวร 66-0034 Au Bon Pain  @ Sathorn City Tower คิงฟิช 6603-0244 แอ้ 2566-03-17 NULL 2566-03-28 IV2303013 2025-09-06 11:06:30 2025-09-06 11:06:30
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 2304
2304 2023-04-03 Fitting ตะขอเกี่ยวตัว S 2566-04-10 SSL-60 20.00 อัน 13.50 14.45 288.90 PR6604016 หน่อย 66-0227 Bakery Display @ Big C Bang Bon แพนสยาม 6605-0065 นัท 2566-04-04 2566-04-06 2566-04-06 สุชาดา/ธนาภา IV6604-00694 2025-09-06 11:06:30 2025-09-06 11:06:30
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 2560
2560 2023-04-22 ไฟฟ้า สแควร์บล๊อก(เหล็ก) 4x4 +ฝา NULL 30.00 ใบ 11.00 11.77 353.10 PR6604152 STOCK แสงใหม่ 6604-0349 แอ้ 2566-04-26 NULL 2566-04-26 นิรันดร์/กรรณิกา SS00123-002828 2025-09-06 11:06:31 2025-09-06 11:06:31
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 2816
2816 NULL NULL 0.00 0.00 0.00 0.00 NULL NULL NULL 2025-09-06 11:06:31 2025-09-06 11:06:31
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 3072
3072 NULL NULL 0.00 0.00 0.00 0.00 NULL NULL NULL 2025-09-06 11:06:32 2025-09-06 11:06:32
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 3328
3328 NULL NULL 0.00 0.00 0.00 0.00 NULL NULL NULL 2025-09-06 11:06:33 2025-09-06 11:06:33
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 3584
3584 NULL NULL 0.00 0.00 0.00 0.00 NULL NULL NULL 2025-09-06 11:06:33 2025-09-06 11:06:33
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 3840
3840 NULL NULL 0.00 0.00 0.00 0.00 NULL NULL NULL 2025-09-06 11:06:34 2025-09-06 11:06:34
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 4096
4096 NULL NULL 0.00 0.00 0.00 0.00 NULL NULL NULL 2025-09-06 11:06:34 2025-09-06 11:06:34
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 4352
4352 NULL NULL 0.00 0.00 0.00 0.00 NULL NULL NULL 2025-09-06 11:06:35 2025-09-06 11:06:35
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 4608
4608 NULL NULL 0.00 0.00 0.00 0.00 NULL NULL NULL 2025-09-06 11:06:36 2025-09-06 11:06:36
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 4864
4864 NULL NULL 0.00 0.00 0.00 0.00 NULL NULL NULL 2025-09-06 11:06:36 2025-09-06 11:06:36
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 5120
5120 NULL NULL 0.00 0.00 0.00 0.00 NULL NULL NULL 2025-09-06 11:06:37 2025-09-06 11:06:37
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 5376
5376 NULL NULL 0.00 0.00 0.00 0.00 NULL NULL NULL 2025-09-06 11:06:37 2025-09-06 11:06:37
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 5632
5632 NULL NULL 0.00 0.00 0.00 0.00 NULL NULL NULL 2025-09-06 11:06:38 2025-09-06 11:06:38
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 5888
5888 NULL NULL 0.00 0.00 0.00 0.00 NULL NULL NULL 2025-09-06 11:06:38 2025-09-06 11:06:38
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 6144
6144 NULL NULL 0.00 0.00 0.00 0.00 NULL NULL NULL 2025-09-06 11:06:39 2025-09-06 11:06:39
Edit Edit Copy Copy Delete Delete
DELETE FROM purchase_orders WHERE `purchase_orders`.`id` = 6400
6400 NULL NULL 0.00 0.00 0.00 0.00 NULL NULL NULL 2025-09-06 11:06:39 2025-09-06 11:06:39
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