Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: csv_db »Table: table 2
Page-related settingsClick 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.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available. Documentation
Showing rows 0 - 24 (6709 total, Query took 0.0021 seconds.)
SELECT * FROM `table 2`
Buyer IDItem CodeDescription
A02 101061-5-001-3510 ALU 101061 P.3510 MF
A02 101061-5-001-3700 ALU 101061 P.3700 MF
A02 101061-5-001-4510 ALU 101061 P.4510 MF
A02 101061-5-001-5010 ALU 101061 P.5010 MF
A02 101061-5-001-5110 ALU 101061 P.5110 MF
A02 101061-5-001-5510 ALU 101061 P.5510 MF
A02 101061-5-001-6000 ALU 101061 P.6000 MF
A02 101061-5-001-6010 ALU 101061 P.6010 MF
A02 101062-5-001-3050 ALU 101062 P.3050 MF
A02 101062-5-001-3100 ALU 101062 P.3100 MF
A02 101300-5-001-3210 ALU 101300 P.3210 MF
A02 101300-5-001-3310 ALU 101300 P.3310 MF
A02 101300-5-001-3450 ALU 101300 P.3450 MF
A02 101300-5-001-3910 ALU 101300 P.3910 MF
A02 101300-5-001-4750 ALU 101300 P.4750 MF
A02 101300-5-001-5000 ALU 101300 P.5000 MF
A02 101300-5-001-5150 ALU 101300 P.5150 MF
A02 101300-5-001-5650 ALU 101300 P.5650 MF
A02 101300-5-001-6000 ALU 101300 P.6000 MF
A02 201002-5-001-6000 ALU 201002 P.6000 MF
A02 201004-5-001-6000 ALU 201004 P.6000 MF
A02 202000-5-001-6000 ALU 202000 P.6000 MF
A02 202001-5-001-6000 ALU 202001 P.6000 MF
A02 202002-5-001-6000 ALU 202002 P.6000 MF
A02 204017-5-001-2020 ALU 204017 P.2020MF