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 `assetsregister3` ORDER BY `AssBrand` DESC 
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts Assess_id Asstype AssBrand Descending Ascending 1 AssSerNo AssBranch AssTagNo AssStatus AssetsClassName Commt CommReason CommDate OldBranch NewBranch InputterBranch ContOrder Username
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 35
35 STRANGER RAPPER STRANGER GZGLS1SCBM0083 KOTOKU CRB/KT/RP/01 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL FELICIA HALLO
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 5
5 CURRENCY BINDER STRANGE GZGLS1SCBM0082 ADEISO CRB/AD/BR/01 Good NULL NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 24
24 MOBILY WIRELESS ROUTER ROUTER G5J6RA93604026 ADEISO COMPUTER & ACCESSORIES
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 64
64 CASH RAPPER RA GZGLSISCBM0568 KUNTUNSE 0 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL JACQUELINE TAYE FORSON
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 28
28 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 assetsregister3 WHERE `assetsregister3`.`Assess_id` = 34
34 EPSON PRINTER PRINTER X7AV023044 KOTOKU CRB/KT/PR/01 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL FELICIA HALLO
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 63
63 Ephson Printer Printer X7AV075399 KUNTUNSE CRB/KUN/RP/01 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL EBENEZER SEKYI TURKSON
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 47
47 ROUTER MOBILY G5J6RAI240601798 KOTOKU CRB/KT/RT/01 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 57
57 Counting Machine MIBG 51336391 KUNTUNSE CRB/KUN/CM/01 Good NULL NULL NULL NULL NULL 427 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 30
30 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 assetsregister3 WHERE `assetsregister3`.`Assess_id` = 74
74 CANON SCANNER LIDE120 KJWW46874 KUNTUNSE
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 13
13 Kojak Online Device Kojak Kj210da-e00 KJ210DA-21600821-E00C ADEISO CRB/AD/KJ/442/01 Good Computer NULL NULL NULL NULL NULL 666 NULL DIANA OWUSU DARKOA
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 33
33 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 assetsregister3 WHERE `assetsregister3`.`Assess_id` = 22
22 PHOTOCOPIER SCANNER IMAGERUNNER 2520 2255RY0007 ADEISO CRB/AD/PHC2 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 38
38 MS0 300 SCANNER IDEMIA SCANNER 2207S000303 KOTOKU 0 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL NANA AMA BRACE
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 76
76 MSO 300 SCANNER IDEMIA SCANNER 2206S000827 KUNTUNSE 0 Good COMPUTER & ACCESSORIES NULL NULL NULL NULL NULL NULL ISAAC OWUSU
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 49
49 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 assetsregister3 WHERE `assetsregister3`.`Assess_id` = 70
70 HP Desktop H290 G4 HP System unit 4CE223CQVR KUNTUNSE CRB/KUN/SU/2405 Good COMPUTER NULL NULL NULL NULL NULL NULL MATTHIAS AFEDI AMANOR
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 18
18 HP NOTEBOOK LAPTOP HP NOTEBOOK LAPTOP CND1271H5H ADEISO CRB/AD/LT/2301 Good COMPUTER NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 14
14 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 assetsregister3 WHERE `assetsregister3`.`Assess_id` = 17
17 HP MONITOR HP MONITOR CNC9190G5R ADEISO CRB/AD/MT/PC2302 Good COMPUTER NULL NULL NULL NULL NULL NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 40
40 Hp Monitor Hp Monitor CNC9190G6F KOTOKU 0 Good Computer NULL NULL NULL NULL NULL 575 NULL NULL
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 45
45 HP Monitor HP Monitor CNK3361JGH KOTOKU CRB/KO/MT/PC2404 Action COMPUTER NULL NULL NULL NULL NULL NULL EMMANEUL SACKEY
Edit Edit Copy Copy Delete Delete
DELETE FROM assetsregister3 WHERE `assetsregister3`.`Assess_id` = 48
48 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 assetsregister3 WHERE `assetsregister3`.`Assess_id` = 71
71 HP Monitor HP Monitor 3CM2251ZVR KUNTUNSE CRB/KUN/MT/2405 Good COMPUTER NULL NULL NULL NULL NULL 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