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 `zra_item_class` ORDER BY `taxTyCd` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts id itemClsCd itemClsNm itemClsLvl taxTyCd Descending Ascending 1 mjrTgYn useYn
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156416
156416 3016190400 Cornices 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156417
156417 4618180200 Safety glasses 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156418
156418 3026640500 Compressed fiber sheet 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156419
156419 9212150200 Burglary protection services 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156420
156420 1112161600 Pine wood 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 324356
324356 1510161300 Raw coal 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156421
156421 9212150300 Guard dog rental 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156422
156422 9212150400 Security guard services 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156423
156423 9212160100 Detective agencies 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 324359
324359 4014174300 Nozzle tips or caps 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156424
156424 9212160200 Fingerprint services 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156425
156425 9212160300 Lie detection services 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156426
156426 9212170200 Fire alarm maintenance or monitoring 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156427
156427 9212170100 Surveillance or alarm maintenance or monitoring 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156428
156428 9212160400 Private investigation services 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156429
156429 9212170400 Confinement surveillance systems maintenance or mo... 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156430
156430 9212170300 Store or business anti theft services 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156431
156431 9212170500 Biometric security systems 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156432
156432 9212180100 Armored car service 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156433
156433 9212180200 Money transport service 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156434
156434 9212180300 Money storage service 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156435
156435 9212190100 Security boat service 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 156437
156437 7611150100 Building cleaning services 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 323400
323400 6012114800 Color paperboard 5 A Y Y
Edit Edit Copy Copy Delete Delete
DELETE FROM zra_item_class WHERE `zra_item_class`.`id` = 323410
323410 8413152001 General Insurance Service 5 A Y Y
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