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
Options
Set default





Collapse Expand Requery Edit Explain Profiling 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 `employeesbio`
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts EmployeeBioId EmployeeId BioType BioVersion BioIndex BioId Bio BioFormatId
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 215 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 0 AND `employeesbio`.`BioFormatId` = 0
1762 215 Fingerprint 10 0 0 TfdTUzIxAAAEtLkECAUHCc7QAAActWkBAAAAhFkvmbQcAAEPkA... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 125 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 4 AND `employeesbio`.`BioFormatId` = 0
14810938 125 Fingerprint 10 0 4 Sl9TUzIxAAADHB8ECAUHCc7QAAAbHWkBAAAAg8EczRwiAJEOaA... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 78 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 6 AND `employeesbio`.`BioFormatId` = 0
14810984 78 Fingerprint 10 0 6 SvNTUzIxAAADsLQECAUHCc7QAAAbsWkBAAAAg10iLrAXAAQPbA... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 58 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 3 AND `employeesbio`.`BioFormatId` = 0
1559 58 Fingerprint 10 0 3 StNTUzIxAAADkJIECAUHCc7QAAAbkWkBAAAAg70ezZAYABEOjQ... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 74 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 4 AND `employeesbio`.`BioFormatId` = 0
1560 74 Fingerprint 10 0 4 TTtTUzIxAAAEeH0ECAUHCc7QAAAceWkBAAAAhKUpYXhxAPsPqA... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 358 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 6 AND `employeesbio`.`BioFormatId` = 0
1999 358 Fingerprint 10 0 6 TfNTUzIxAAAEsLQECAUHCc7QAAAcsWkBAAAAhF0wrLAtAIcPYQ... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 232 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 4 AND `employeesbio`.`BioFormatId` = 0
1784 232 Fingerprint 10 0 4 TedTUzIxAAAEpKYECAUHCc7QAAAcpWkBAAAAhEkriaQ6APQPoA... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 246 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 1 AND `employeesbio`.`BioFormatId` = 0
1843 246 Fingerprint 10 0 1 Sq9TUzIxAAAD7PAECAUHCc7QAAAb7WkBAAAAgxEcW+wnAPwPaQ... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 243 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 5 AND `employeesbio`.`BioFormatId` = 0
1844 243 Fingerprint 10 0 5 TKFTUzIxAAAF4uUECAUHCc7QAAAd42kBAAAAhQ89peIUAIwPyA... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 280 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 0 AND `employeesbio`.`BioFormatId` = 0
1938 280 Fingerprint 10 0 0 So9TUzIxAAADzM4ECAUHCc7QAAAbzWkBAAAAg3EZ7cw/ABoPKg... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 93 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 6 AND `employeesbio`.`BioFormatId` = 0
1616 93 Fingerprint 10 0 6 TEVTUzIxAAAFBgkECAUHCc7QAAAdB2kBAAAAhCsyjwY8AH4PfQ... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 182 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 0 AND `employeesbio`.`BioFormatId` = 0
1713 182 Fingerprint 10 0 0 TVlTUzIxAAAEGh0ECAUHCc7QAAAcG2kBAAAAhMcqsBonAEMLvQ... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 142 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 0 AND `employeesbio`.`BioFormatId` = 0
1636 142 Fingerprint 10 0 0 Sr9TUzIxAAAD/AMECAUHCc7QAAAb/WkBAAAAgyEjgfxFAHUP6w... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 275 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 4 AND `employeesbio`.`BioFormatId` = 0
1948 275 Fingerprint 10 0 4 SpVTUzIxAAAD1tcECAUHCc7QAAAb12kBAAAAg3sWQNYbAO4Pmw... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 118 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 6 AND `employeesbio`.`BioFormatId` = 0
1596 118 Fingerprint 10 0 6 S6tTUzIxAAAC6O8ECAUHCc7QAAAa6WkBAAAAghUUduhQAH4Pdw... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 100 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 8 AND `employeesbio`.`BioFormatId` = 0
1597 100 Fingerprint 10 0 8 SqNTUzIxAAAD4OIECAUHCc7QAAAb4WkBAAAAgw0g1OBHAJYPVg... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 244 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 1 AND `employeesbio`.`BioFormatId` = 0
1860 244 Fingerprint 10 0 1 TG1TUzIxAAAFLjEECAUHCc7QAAAdL2kBAAAAhdMoty5DAAMP8Q... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 1 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 4 AND `employeesbio`.`BioFormatId` = 0
1525 1 Fingerprint 10 0 4 TdNTUzIxAAAEkJIECAUHCc7QAAAckWkBAAAAhL0muZATAP4Ojw... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 230 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 0 AND `employeesbio`.`BioFormatId` = 0
1787 230 Fingerprint 10 0 0 SuVTUzIxAAADpqkECAUHCc7QAAAbp2kBAAAAg0sfiqZJAJ0Pbg... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 106 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 3 AND `employeesbio`.`BioFormatId` = 0
1617 106 Fingerprint 10 0 3 TWdTUzIxAAAEJCgECAUHCc7QAAAcJWkBAAAAhMkhXyQdAHEPng... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 213 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 0 AND `employeesbio`.`BioFormatId` = 0
1765 213 Fingerprint 10 0 0 T3VTUzIxAAAGNjcECAUHCc7QAAAeN2kBAAAAhttAszYsAAYPYQ... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 197 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 1 AND `employeesbio`.`BioFormatId` = 0
1700 197 Fingerprint 10 0 1 S51TUzIxAAAC3t0ECAUHCc7QAAAa32kBAAAAggMSjN5AAJUPfQ... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 179 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 3 AND `employeesbio`.`BioFormatId` = 0
1701 179 Fingerprint 10 0 3 TQ1TUzIxAAAETkwECAUHCc7QAAAcT2kBAAAAhPMpSk5fAAcPOQ... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 275 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 0 AND `employeesbio`.`BioFormatId` = 0
1890 275 Fingerprint 10 0 0 TZ9TUzIxAAAE3OEECAUHCc7QAAAc3WkBAAAAhAEwc9wQAAYPxw... 0
Edit Edit Copy Copy Delete Delete
DELETE FROM employeesbio WHERE `employeesbio`.`EmployeeId` = 13 AND `employeesbio`.`BioType` = 'Fingerprint' AND `employeesbio`.`BioIndex` = 0 AND `employeesbio`.`BioId` = 0 AND `employeesbio`.`BioFormatId` = 0
1526 13 Fingerprint 10 0 0 Su9TUzIxAAADrLMECAUHCc7QAAAbrWkBAAAAg1Eafaw6AG8OvA... 0
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view