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_posts` ORDER BY `post_parent` ASC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts ID post_author post_date post_date_gmt post_content post_title post_excerpt post_status comment_status ping_status post_password post_name to_ping pinged post_modified post_modified_gmt post_content_filtered post_parent Ascending Descending 1 guid menu_order post_type post_mime_type comment_count
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 1
1 1 2025-11-27 06:13:35 2025-11-27 06:13:35 <!-- wp:paragraph -->
<p>Welcome to WordPress. Thi...
Hello world! publish open open hello-world 2025-11-27 06:13:35 2025-11-27 06:13:35 0 http://localhost/tpgit/?p=1 0 post 1
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 2
2 1 2025-11-27 06:13:35 2025-11-27 06:13:35 <!-- wp:paragraph -->
<p>This is an example page. ...
Sample Page publish closed open sample-page 2025-11-27 06:13:35 2025-11-27 06:13:35 0 http://localhost/tpgit/?page_id=2 0 page 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 3
3 1 2025-11-27 06:13:35 2025-11-27 06:13:35 <!-- wp:heading -->
<h2 class="wp-block-heading">W...
Privacy Policy draft closed open privacy-policy 2025-11-27 06:13:35 2025-11-27 06:13:35 0 http://localhost/tpgit/?page_id=3 0 page 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 4
4 0 2025-11-27 06:13:36 2025-11-27 06:13:36 <!-- wp:page-list /--> Navigation publish closed closed navigation 2025-11-27 06:13:36 2025-11-27 06:13:36 0 http://localhost/tpgit/2025/11/27/navigation/ 0 wp_navigation 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 11
11 1 2014-02-26 10:55:20 2014-02-26 10:55:20 [caption id="attachment_5464" align="alignright" w... DEPARTMENTS publish closed closed departments 2014-02-26 10:55:20 2014-02-26 10:55:20 0 http://localhost/tpgit/?page_id=11 2 page 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 13
13 1 2014-02-26 10:55:41 2014-02-26 10:55:41 [caption id="attachment_1745" align="aligncenter" ... LIBRARY publish closed closed library 2025-11-28 06:42:45 2025-11-28 06:42:45 0 http://localhost/tpgit/?page_id=13 3 page 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 15
15 1 2014-02-26 10:56:12 2014-02-26 10:56:12 <p style="text-align: justify;"><span style="color... PLACEMENT publish closed open placement 2025-11-28 06:55:55 2025-11-28 06:55:55 0 http://localhost/tpgit/?page_id=15 4 page 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 17
17 1 2014-02-26 10:56:47 2014-02-26 10:56:47 [caption id="attachment_1652" align="alignleft" wi... PHOTOGALLERY publish closed closed alumini 2014-02-26 10:56:47 2014-02-26 10:56:47 0 http://localhost/tpgit/?page_id=17 6 page 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 22
22 1 2014-02-26 10:58:48 2014-02-26 10:58:48 <p style="text-align: justify;"><span style="color... HOSTELS publish closed closed hostels 2014-02-26 10:58:48 2014-02-26 10:58:48 0 http://localhost/tpgit/?page_id=22 7 page 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 24
24 1 2014-02-26 10:59:32 2014-02-26 10:59:32 <p style="margin: 0cm 0cm 10.2pt; text-align: cent... CONTACT US publish closed closed contact-us 2014-02-26 10:59:32 2014-02-26 10:59:32 0 http://localhost/tpgit/?page_id=24 8 page 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 520
520 1 2014-05-11 11:50:41 2014-05-11 11:50:41 <h2><span style="color: #0000ff;">Department of Ci... Faculty & Staff Details publish closed closed staff-details 2025-12-08 10:12:40 2025-12-08 10:12:40 0 http://localhost/tpgit/?page_id=520 5 page 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 529
529 1 2014-05-11 11:56:42 2014-05-11 11:56:42 <h2 style="text-align: center;"><span style="color... Lab Facilities publish closed closed lab-facilities 2014-05-11 11:56:42 2014-05-11 11:56:42 0 http://localhost/tpgit/?page_id=529 4 page 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 1262
1262 1 2014-07-18 02:24:27 2014-07-18 02:24:27 <a href="http://localhost/tpgit/wp-content/uploads... STUDENT CORNER publish closed closed student-corner 2025-11-28 06:57:52 2025-11-28 06:57:52 0 http://localhost/tpgit/?page_id=1262 4 page 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 2364
2364 1 2014-11-11 01:13:50 2014-11-11 01:13:50 <p align="justify"><span style="color: #003366;">W... ABOUT US publish closed closed about-us 2014-11-11 01:13:50 2014-11-11 01:13:50 0 http://localhost/tpgit/?page_id=2364 1 page 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 2616
2616 1 2014-11-29 14:20:30 2014-11-29 14:20:30 <table width="516">
<tbody>
<tr>
<td colspan="2" w...
Hostel Officials publish closed closed hostel-officials 2025-12-08 06:47:16 2025-12-08 06:47:16 0 http://localhost/tpgit/?page_id=2616 3 page 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 2917
2917 1 2015-06-05 10:25:29 2015-06-05 10:25:29 <marquee behavior="alternate" bgcolor="#66cd00" st... Election 2016 Voter Awareness publish closed closed state-level-student-projects 2015-06-05 10:25:29 2015-06-05 10:25:29 0 http://tpgit.edu.in/?p=2917 0 post 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 2926
2926 1 2015-06-24 08:14:31 2015-06-24 08:14:31 <script type="text/javascript">// <![CDATA[
if(his...
Circulars publish closed closed circulars 2015-06-24 08:14:31 2015-06-24 08:14:31 0 http://tpgit.edu.in/?p=2926 0 post 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 2929
2929 1 2015-06-24 08:18:39 2015-06-24 08:18:39 <form action="http://tpgit.edu.in/cserver.php" met... Circular Login publish closed closed circular-login-2 2015-06-24 08:18:39 2015-06-24 08:18:39 0 http://tpgit.edu.in/?p=2929 0 post 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 2934
2934 1 2015-06-25 07:20:38 2015-06-25 07:20:38 <center><div dir="auto"><strong><span style="color... Epulz19 publish closed closed zoho-corporation-pvt-ltd-campus-drive 2015-06-25 07:20:38 2015-06-25 07:20:38 0 http://tpgit.edu.in/?p=2934 0 post 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 3006
3006 1 2015-07-14 11:12:42 0000-00-00 00:00:00 <p style="text-align: center;">GOVERNMENT OF TAMIL... draft open open 2015-07-14 11:12:42 0000-00-00 00:00:00 0 http://tpgit.edu.in/?p=3006 0 post 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 3176
3176 1 2016-02-03 09:24:28 2016-02-03 09:24:28 <a href="http://tpgit.edu.in/wp-content/uploads/20... College Day Celebration 2018 publish closed closed alumni-meet-2016 2016-02-03 09:24:28 2016-02-03 09:24:28 0 http://tpgit.edu.in/?p=3176 0 post 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 3194
3194 1 2016-02-17 11:34:35 2016-02-17 11:34:35 <a href="http://tpgit.edu.in/wp-content/uploads/20... Hostel Day "Le'Spirit 17" publish closed closed hostel-mess-contract 2016-02-17 11:34:35 2016-02-17 11:34:35 0 http://tpgit.edu.in/?p=3194 0 post 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 3237
3237 1 2016-03-17 10:34:35 2016-03-17 10:34:35 <img src="http://tpgit.edu.in/wp-content/uploads/2... Tpgit News Letters publish closed closed tpgit-news-letters 2016-03-17 10:34:35 2016-03-17 10:34:35 0 http://tpgit.edu.in/?p=3237 0 post 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 3314
3314 1 2016-04-01 11:49:03 2016-04-01 11:49:03 <a href="http://tpgit.edu.in/wp-content/uploads/20... Annual Sports Day 2018 publish closed closed motivational-talk-on-opportunities-for-engineering... 2016-04-01 11:49:03 2016-04-01 11:49:03 0 http://tpgit.edu.in/?p=3314 0 post 0
Edit Edit Copy Copy Delete Delete
DELETE FROM wp_posts WHERE `wp_posts`.`ID` = 3514
3514 1 2016-07-14 11:49:24 2016-07-14 11:49:24 <p style="text-align: center;"><a href="http://tpg... 27th Graduation Day publish closed closed anti-ragging-legal-awareness-camp 2016-07-14 11:49:24 2016-07-14 11:49:24 0 http://tpgit.edu.in/?p=3514 0 post 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