Recent
Favorites

Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: sams »Table: number_definition
Page-related settingsClick 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.

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 (377 total, Query took 0.0126 seconds.) [number: 601... - 412...]
SELECT * FROM `number_definition` ORDER BY `number`  DESC
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
|
Number of rows:
Filter rows:
Sort by key:
Full textsidtitleshort_codenumber Descending Ascending 1value
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2261
2261 Employer Contribution to NPS pay_head 601 contrib_nps_uni
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2209
2209 Net Pay (A+B-C) pay_head 500 net_pay
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2208
2208 Deduction (C) pay_head 499 deduction
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2247
2247 NIC pay_head 440 nic
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2233
2233 PU Group A B Officer Welfare Association pay_head 439 pugabowa
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2232
2232 PU Ministerial Non Ministerial Welfare Association pay_head 438 pum_nmswa
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2231
2231 Group D Association pay_head 437 grp_d_asso
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2230
2230 PU Office Association pay_head 436 puoa
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2229
2229 SC ST Association pay_head 435 sc_st_asso
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2282
2282 CANFIN Housing Loan pay_head 427 canfin
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2207
2207 Bon Ded pay_head 426 bon_ded
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2206
2206 Pondy State Co-op pay_head 425 pond_co_op
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2205
2205 CRE SOC DU pay_head 424 cre_soc_du
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2204
2204 Delhi University pay_head 423 delhi_uni
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2203
2203 Health Centre Contrb. pay_head 422 health_cen
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2202
2202 Pondy Co-op Centl Land Devp. Bank pay_head 421 land_devel
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2201
2201 PCDW DAP pay_head 420 pcdw_dap
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2200
2200 Pondicherry Co-op Bank pay_head 419 pondyco_op
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2199
2199 Indian Bank Karaikal pay_head 418 ib_kkl
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2198
2198 PU Grp A & B officer Assoc. pay_head 417 pugabowa
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2197
2197 PU Mins & Non-mins Assoc. pay_head 416 pum_nmswa
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2196
2196 Canara Bank PEC pay_head 415 can_ban_pe
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2195
2195 IOB pay_head 414 iob
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2194
2194 LIC House Loan pay_head 413 lic_house
Edit EditCopy CopyDelete Delete
DELETE FROM `number_definition` WHERE `number_definition`.`id` = 2193
2193 Indian Bank PU pay_head 412 ind_bnk
With selected: With selected:

|
|
|
|
Number of rows:
Filter rows:
Sort by key:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport Export Display chart Display chart Create view Create view

Bookmark this SQL query Bookmark this SQL query
mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
Connection for controluser as defined in your configuration failed.