Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: hmis »Table: brandnames
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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
Showing rows 0 - 24 (123 total, Query took 0.0155 seconds.)
SELECT * FROM `brandnames`

Full texts id major_id major_code major_desc brand_code brand_desc create_date created_by modified_date modified_by locationname
1 1 PHR Pharmacy MIC MICRO 2017-06-10 04:54:03 20 0000-00-00 00:00:00 0 NULL
2 1 PHR Pharmacy CIP CIPLA 2017-06-10 04:55:59 20 0000-00-00 00:00:00 0 NULL
3 1 PHR Pharmacy AJN Ajanta 2017-06-10 06:10:38 20 0000-00-00 00:00:00 0 NULL
4 1 PHR Pharmacy JAWA JAWA 2017-06-11 23:40:33 20 0000-00-00 00:00:00 0 NULL
5 1 PHR Pharmacy ALLERGAN ALLERGAN INDIA 2017-06-11 23:47:24 20 0000-00-00 00:00:00 0 NULL
6 1 PHR Pharmacy SUN SUN WAYS 2017-06-12 00:05:54 20 0000-00-00 00:00:00 0 NULL
7 1 PHR Pharmacy AL ALCON INDIA 2017-06-12 00:08:00 20 0000-00-00 00:00:00 0 NULL
8 1 PHR Pharmacy SU SUN PHARMA 2017-06-12 00:08:34 20 0000-00-00 00:00:00 0 NULL
9 1 PHR Pharmacy INDO INDOCO REMDIES 2017-06-12 00:14:04 20 0000-00-00 00:00:00 0 NULL
10 1 PHR Pharmacy INT INTAS PHARMACITECAL 2017-06-12 00:14:04 20 0000-00-00 00:00:00 0 NULL
11 1 PHR Pharmacy ORG ORGANY LABORETORI 2017-06-12 00:14:04 20 0000-00-00 00:00:00 0 NULL
12 3 GEN General CEN CENTURY 2017-06-12 03:39:03 30 0000-00-00 00:00:00 0 NULL
13 1 PHR Pharmacy ABH ABHYUDAY CARE 2017-06-12 06:14:24 20 0000-00-00 00:00:00 0 NULL
14 1 PHR Pharmacy AUR AUROLAB 2017-06-12 06:14:24 20 0000-00-00 00:00:00 0 NULL
15 1 PHR Pharmacy SEN SENTISS PHARMA 2017-06-12 06:14:24 20 0000-00-00 00:00:00 0 NULL
16 1 PHR Pharmacy PAN PANJON PHARMA 2017-06-12 06:14:24 20 0000-00-00 00:00:00 0 NULL
17 1 PHR Pharmacy EYE EYECURE 2017-06-12 06:14:24 20 0000-00-00 00:00:00 0 NULL
18 1 PHR Pharmacy ZOD ZODLEY PHARMACEUTICALS 2017-06-12 06:14:24 20 0000-00-00 00:00:00 0 NULL
19 1 PHR Pharmacy DAK DAKSH PHARMACEUTICALS 2017-06-12 06:14:24 20 0000-00-00 00:00:00 0 NULL
20 1 PHR Pharmacy EFI EFICAZ HELTHCARE 2017-06-12 06:14:24 20 0000-00-00 00:00:00 0 NULL
21 1 PHR Pharmacy KAL KALARSEN 2017-06-12 06:14:24 20 0000-00-00 00:00:00 0 NULL
22 1 PHR Pharmacy SAV SAIVIS 2017-06-12 06:14:24 20 0000-00-00 00:00:00 0 NULL
23 1 PHR Pharmacy CAN CANDURE 2017-06-12 06:14:24 20 0000-00-00 00:00:00 0 NULL
24 1 PHR Pharmacy OPT OPTHO 2017-06-12 06:14:24 20 0000-00-00 00:00:00 0 NULL
25 1 PHR Pharmacy USV USV LIMITED 2017-06-12 06:21:57 20 0000-00-00 00:00:00 0 NULL