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 `wp_postmeta`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts meta_id post_id meta_key meta_value
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 1
1 2 _wp_page_template default
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 2
2 3 _wp_page_template default
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 3
3 6 _wp_attached_file woocommerce-placeholder.webp
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 4
4 6 _wp_attachment_metadata a:6:{s:5:"width";i:1200;s:6:"height";i:1200;s:4:"f...
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 7
7 14 _wcpa_fb_json_data {"sec_76ae827f7a0e34":{"extra":{"key":"sec_76ae827...
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 8
8 14 _wcpa_fb_formula_data {"variables":[],"formulas":[]}
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 668
668 60 _sku BRAND-19
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 669
669 60 total_sales 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 670
670 60 _tax_status taxable
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 671
671 60 _tax_class
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 672
672 60 _manage_stock no
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 673
673 60 _backorders no
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 674
674 60 _sold_individually no
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 675
675 60 _virtual no
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 676
676 60 _downloadable no
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 677
677 60 _download_limit -1
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 678
678 60 _download_expiry -1
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 679
679 60 _stock NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 680
680 60 _stock_status instock
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 681
681 60 _wc_average_rating 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 682
682 60 _wc_review_count 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 683
683 60 _product_attributes a:1:{s:42:"%d8%a7%d9%84%d9%85%d9%88%d8%af%d9%8a%d9...
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 684
684 60 _product_version 11.2.1
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 685
685 61 _variation_description
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_postmeta WHERE `wp_postmeta`.`meta_id` = 686
686 61 _sku G19-M1111
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