Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: herp »Table: accountledger
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 (1251 total, Query took 0.0005 seconds.)
SELECT * FROM `accountledger`

Full texts AccountsID CompanyId vender_client taxid openingtype openingBalance AccountName Identification MaintainSubLed AccountsType BankName BankBranch BankAccountsType BankRateofInt UnderGroup SubLedger AnalysesCode LinkWithEmp MultiCurrency CurrencyId GroupId NatureId MGID Inactive GLBaseCurrency ledgertype openingdate
1 3 NULLNULLNULLNULLBCL INPLANT & OTHERS CHARGES 0 0 188 0 0 0 0 0 0 1 income NULL
4 3 NULLNULLNULLNULLRETINA OPERATION CHARGES 0 0 188 0 0 0 0 0 0 1 income NULL
6 3 NULLNULLNULLNULLB SCAN CHARGES 0 0 188 0 0 0 0 0 0 1 income NULL
7 3 NULLNULLNULLNULLOTHERS OPERATION CHARGES 0 0 188 0 0 0 0 0 0 1 income NULL
8 3 NULLNULLNULLNULLG. ANESTHESIYA CHARGES 0 0 188 0 0 0 0 0 0 1 income NULL
9 3 NULLNULLNULLNULLRETINA & GLAUCOMA TEST CHARGES 0 0 188 0 0 0 0 0 0 1 income NULL
11 3 NULLNULLNULLNULLGLASS EYE CHARGES 0 0 188 0 0 0 0 0 0 1 income NULL
13 3 NULLNULLNULLNULLINJECTION CHARGES 0 0 188 0 0 0 0 0 0 1 income NULL
15 3 NULLNULLNULLNULLGLAUCOMA OPERATION CHARGES 0 0 188 0 0 0 0 0 0 1 income NULL
17 3 NULLNULLNULLNULLNON IOL OPERATION CHARGES 0 0 188 0 0 0 0 0 0 1 income NULL
18 3 NULLNULLNULLNULLBLOOD TEST CHARGES 0 0 188 0 0 0 0 0 0 1 income NULL
22 3 NULLNULLNULLNULLREGISTRATION CHARGES-NORMAL 0 0 188 0 0 0 0 0 0 1 income NULL
23 3 NULLNULLNULLNULLIOL OPERATION CHARGES 0 0 188 0 0 0 0 0 0 1 income NULL
24 3 NULLNULLNULLNULLOTHERS CHARGES 0 0 188 0 0 0 0 0 0 1 income NULL
26 3 NULLNULLNULLNULLYAG LASER CHARGES 0 0 188 0 0 0 0 0 0 1 income NULL
27 3 NULLNULLNULLNULLMobile (Corporate Sim) Expenses 0 0 193 0 0 0 0 0 0 1 expence NULL
28 3 NULLNULLNULLNULLTelephone & Telegrame (Land line & others) Exp. 0 0 193 0 0 0 0 0 0 1 expence NULL
29 3 NULLNULLNULLNULLAdvertisment & Publicity 0 0 193 0 0 0 0 0 0 1 expence NULL
30 3 NULLNULLNULLNULLBoarding Fooding & Training   0 0 193 0 0 0 0 0 0 1 expence NULL
31 3 NULLNULLNULLNULLDonation Given 0 0 193 0 0 0 0 0 0 1 expence NULL
32 3 NULLNULLNULLNULLElectricity Charges-Hospital 0 0 193 0 0 0 0 0 0 1 expence NULL
33 3 NULLNULLNULLNULLEntertainment Expenses 0 0 193 0 0 0 0 0 0 1 expence NULL
34 3 NULLNULLNULLNULLFire Protection & Safety 0 0 193 0 0 0 0 0 0 1 expence NULL
35 3 NULLNULLNULLNULLFreight & Cartage 0 0 193 0 0 0 0 0 0 1 expence NULL
36 3 NULLNULLNULLNULLGeneral & Miscellaneous Expenses 0 0 193 0 0 0 0 0 0 1 expence NULL