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 `assetsregister2` ORDER BY `Username` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts Assess_id Asstype AssBrand AssSerNo AssBranch AssTagNo AssStatus AssetsClassName Commt CommReason CommDate OldBranch NewBranch InputterBranch ContOrder Username Descending Ascending 1
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 629
629 SYSTEM UNIT HP 4ce124x6xm ADEISO CRBADSUPC2301 Good COMPUTER NULL NULL NULL NULL NULL NULL WILLIAM ODEI GYAMFI
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 630
630 MONITOR HP 3cq21908bk ADEISO CRBADMTPC2301 Good COMPUTER NULL NULL NULL NULL NULL NULL WILLIAM ODEI GYAMFI
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 631
631 UPS GENERAL E2205113515 ADEISO CRBADUPS2301 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL WILLIAM ODEI GYAMFI
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 664
664 Ups  2000va General Ups 2000va 310040473DC0381000403 HEADOFFICE CRB/OP/UPS/2405 Good Computer NULL NULL NULL NULL NULL 664 NULL WILLIAM ODEI GYAMFI
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 668
668 KOJAK online device Kojak Kj210da-e00 KJ210DA-21600822-E00C KOTOKU CRB/KO/KJ/442/01 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL STEPHEN BAYO
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 627
627 SYSTEM UNIT HP 7JNMDN2 NSAWAM CRB/NS/03 Good COMPUTER NULL NULL NULL NULL NULL NULL STELLA ARTHUR
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 628
628 MONITOR DELL CN-OT9Y04-FCC00-75N-A3HB-A00 NSAWAM CRB/NS/PC-4 Good COMPUTER NULL NULL NULL NULL NULL NULL STELLA ARTHUR
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 659
659 HP Desktop H290 G4 HP System Unit 4CE223CPV5 NSAWAM CRB/NS/PC/24 Good COMPUTER NULL NULL NULL NULL NULL NULL STELLA ARTHUR
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 661
661 HP Monitor HP Monitor 3CM2302335 NSAWAM CRB/NS/PC/24 Good COMPUTER NULL NULL NULL NULL NULL NULL STELLA ARTHUR
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 647
647 UPS General  2000VA 310040473DC0381000280 ADEISO CRB/AD/UPS/2404 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL RICHMOD OSEI KUMI
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 652
652 HP Desktop H290 G4 HP Desktop H290 G4 4CE22CPWY ADEISO CRB/AD/SU/2405 Good COMPUTER NULL NULL NULL NULL NULL NULL RICHMOD OSEI KUMI
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 654
654 HP Monitor HP Monitor 3CM2251YZ6 ADEISO CRB/AD/MT/2405 Good COMPUTER NULL NULL NULL NULL NULL NULL RICHMOD OSEI KUMI
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 617
617 HP LAPTOP HP 00 KOTOKU CRB/KT/LT/02 Good COMPUTER NULL NULL NULL NULL NULL NULL RICHARD KWAKYE
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 642
642 CanoScan LIDE 300 CANON KNUV80301 NSAWAM 0000 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL REGAN YEBOAH
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 662
662 HP Printer LaserJet Mfp M436n HP Printer LaserJet Mfp M436n CNBIM8G1V4 HEADOFFICE CRB/HO/PR/24 Good COMPUTER NULL NULL NULL NULL NULL NULL REGAN YEBOAH
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 657
657 HP Desktop H290 G4 HP System unit 4CE223CRBD KOTOKU CRB/KO/SU/2401 Good COMPUTER NULL NULL NULL NULL NULL NULL PATRICK DDZOSSOU
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 658
658 HP Monitor HP Monitor CNK336IJGH KOTOKU CRB/KO/MT/2401 Good COMPUTER NULL NULL NULL NULL NULL NULL PATRICK DDZOSSOU
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 607
607 System Unit HP 4CE12024VK KOTOKU CRB/KO/SU/PC2302 Good COMPUTER NULL NULL NULL NULL NULL NULL NANA AMA BRACE
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 608
608 MONITOR HP 3CQ21909H1 KOTOKU CRB/KO/MT/PC2302 Good COMPUTER NULL NULL NULL NULL NULL NULL NANA AMA BRACE
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 609
609 HP LASERJET M130A PRINTER VNFRF03093 KOTOKU CRB/KO/PR/01 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL NANA AMA BRACE
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 610
610 ONLINE SCANNER-NIA COLUMBO CD119CA-22300063-00C KOTOKU 000 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL NANA AMA BRACE
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 611
611 OFFLINE SCANNER-NIA M-ECO 1009356 KOTOKU CE1-CID-16-4G-11 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL NANA AMA BRACE
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 638
638 ACS DUAL READER ACS RR595-001049 KOTOKU 000 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL NANA AMA BRACE
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 639
639 MS0 300 SCANNER IDEMIA SCANNER 2207S000303 KOTOKU 000 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL NANA AMA BRACE
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister2 WHERE `assetsregister2`.`Assess_id` = 648
648 Ups 2000va General 2000va 310040473DC0381000262 KUNTUNSE CRB/KUT/UPS/2404 Good Computer & Accessories NULL NULL NULL NULL NULL 648 NULL MATTHIAS AFEDI AMANOR
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