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 `dinspection` ORDER BY `instime` ASC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts dinid plmid userid insdate insokqty mcid dinuserid instime Ascending Descending 1 entrydate shiftid rollno trolyno rollwidth tfault_points point_sqyd result dinrid dshid plid dinstid rproqty inspection_notes gradding gradding_notes
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100358
100358 3011 74 2017-03-12 50.00 45 NULL 01:20:36 2017-03-12 1 12 NULL 57.00 0 0.00 NULL NULL NULL NULL 1 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100346
100346 3005 NULL 2017-01-12 58.00 47 NULL 01:21:57 2017-01-12 2 52583 NULL 56.00 0 0.00 NULL NULL NULL NULL 2 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100025
100025 2706 1 2016-06-07 6253.00 42 20 01:33:40 2016-06-07 2 test NULL 56.00 285 0.00 Pass 26 2 NULL NULL 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100026
100026 2706 1 2016-06-07 199.24 46 18 01:34:04 2016-06-07 3 test-23 NULL 57.00 234 0.00 Fail 26 5 NULL NULL 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100329
100329 3011 1 2017-01-10 33.00 43 NULL 01:39:13 2017-01-10 1 1/1 NULL 56.00 0 0.00 NULL NULL NULL NULL 1 33.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100330
100330 3005 1 2017-01-10 33.00 44 NULL 01:39:30 2017-01-10 1 33 NULL 56.00 0 0.00 Pass NULL 1 NULL 2 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100331
100331 29348 1 2017-01-10 33.00 43 NULL 01:42:42 2017-01-10 1 1/1 NULL 56.00 0 0.00 Pass NULL 15 NULL 3 33.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100332
100332 29348 1 2017-01-10 33.00 43 NULL 01:44:31 2017-01-10 1 1/1 NULL 56.00 0 0.00 NULL NULL NULL NULL 3 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100328
100328 3011 1 2016-12-10 180.00 55 NULL 01:51:11 2016-12-10 1 2345657 NULL 57.00 0 0.00 Pass NULL 15 NULL 1 180.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100333
100333 29348 1 2017-01-10 33.00 43 NULL 01:51:43 2017-01-10 1 1/1 NULL 56.00 0 0.00 NULL NULL NULL NULL 3 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100392
100392 34426 259 2017-05-12 140.00 52 NULL 01:51:46 2017-05-12 1 21/1123 NULL 57.00 0 0.00 NULL NULL NULL NULL 3475 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100334
100334 29348 1 2017-01-10 33.00 45 NULL 01:53:16 2017-01-10 1 1/1 NULL 56.00 0 0.00 NULL NULL NULL NULL 3 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100335
100335 29348 1 2017-01-10 33.00 43 NULL 01:56:01 2017-01-10 1 1/1 NULL 56.00 0 0.00 NULL NULL NULL NULL 3 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100336
100336 29348 1 2017-01-10 33.00 43 NULL 01:57:32 2017-01-10 1 1/1 NULL 56.00 0 0.00 NULL NULL NULL NULL 3 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100337
100337 29348 1 2017-01-10 33.00 43 NULL 01:58:40 2017-01-10 1 1/1 NULL 56.00 0 0.00 NULL NULL NULL NULL 3 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100338
100338 29348 1 2017-01-10 33.00 42 NULL 01:59:05 2017-01-10 1 1/1 NULL 56.00 0 0.00 NULL NULL NULL NULL 3 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100059
100059 24630 74 2016-06-16 53.00 63 NULL 02:19:36 2016-06-16 1 32/10001 NULL 54.00 16 0.00 Pass 5911 1 NULL NULL 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100060
100060 24630 74 2016-06-16 44.00 63 NULL 02:20:44 2016-06-16 1 32/10002 NULL 54.00 8 0.00 Pass 5911 1 NULL NULL 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100061
100061 24630 74 2016-06-16 25.00 63 NULL 02:21:26 2016-06-16 1 32/1003 NULL 54.00 7 0.00 Pass 5911 1 NULL NULL 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100062
100062 24630 74 2016-06-16 41.00 63 NULL 02:23:25 2016-06-16 1 32/10004 NULL 54.00 0 0.00 Pass 5911 6 NULL NULL 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100063
100063 24630 74 2016-06-16 68.00 63 NULL 02:24:21 2016-06-16 1 32/10005 NULL 54.00 10 0.00 Pass 5911 3 NULL NULL 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100064
100064 24630 74 2016-06-16 85.00 63 NULL 02:25:31 2016-06-16 1 32/10006 NULL 54.00 16 0.00 Pass 5911 2 NULL NULL 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100065
100065 24630 74 2016-06-16 140.00 63 NULL 02:26:33 2016-06-16 1 32/10007 NULL 54.00 24 0.00 Pass 5911 2 NULL NULL 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100066
100066 24630 74 2016-06-16 158.00 63 NULL 02:27:06 2016-06-16 1 32/10008 NULL 54.00 20 0.00 Pass 5911 3 NULL NULL 0.00 NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM dinspection WHERE `dinspection`.`dinid` = 100067
100067 24630 74 2016-06-16 135.00 63 NULL 02:28:21 2016-06-16 1 32/10009 NULL 54.00 20 0.00 Pass 5911 2 NULL NULL 0.00 NULL NULL NULL
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