Recent
Favorites

Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: pu_recruitment_nt »Table: payment_bill_desk
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 (300 total, Query took 0.0849 seconds.)
SELECT * FROM `payment_bill_desk`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
|
Number of rows:
Filter rows:
Sort by key:
Full textsiduser_idreg_idapp_nopost_idsams_trans_nosams_amountstatusfee_typeyearpost_paramMerchantIDCustomerIDTxnReferenceNoBankReferenceNoTxnAmountBankIDBankMerchantIDTxnTypeCurrencyNameItemCodeSecurityTypeSecurityIDSecurityPasswordTxnDateAuthStatusSettlementTypeAdditionalInfo1AdditionalInfo2AdditionalInfo3AdditionalInfo4AdditionalInfo5AdditionalInfo6AdditionalInfo7ErrorStatusErrorDescriptionresponseCheckSumamount_descriptiondate_modifieddate_created_olddate_created
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 1
1 19 2000019 200001901 3 BD2000019REC2411 2000 S 0 2020 IBPONDIUVY|BD2000019REC2411|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000019REC2411 SSBI9210766494 IGAJJLLMJ6 00002000.0 SBI NA 01 INR DIRECT NA NA 17.70 11-09-2020 11:30:39 0300 NA NA NA NA NA NA NA NA NA Completed successfully. IBPONDIUVY|BD2000019REC2411|SSBI9210766494|IGAJJLL... C6751FECEF8359B64277E2F8AAED7BB81218034169A65CF020... Pondicherry University - Recruitment - Application... 2020-09-11 11:25:56 2020-09-11 11:24:11
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 2
2 39 2000039 200003901 1 BD2000039REC3447 1000 S 0 2020 IBPONDIUVY|BD2000039REC3447|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000039REC3447 SSM29211714240 191517 1000.00 SM2 517574 03 INR MDDIRECT NA NA 00000000.00 11-09-2020 15:41:32 0300 NA NA NA NA NA NA NA NA NA PGS10001-Success IBPONDIUVY|BD2000039REC3447|SSM29211714240|191517|... CD8BB15B5B486191F63BD7C72F0C5146C1DFD6165D1708BE22... Pondicherry University - Recruitment - Application... 2020-09-11 15:36:27 2020-09-11 15:34:47
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 3
3 45 2000045 200004501 3 BD2000045REC3909 1000 S 0 2020 IBPONDIUVY|BD2000045REC3909|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000045REC3909 SPMP9212546188 926885 1000.00 PMP 557269 03 INR MDDIRECT NA NA 00000000.00 11-09-2020 19:46:39 0300 NA NA NA NA NA NA NA NA NA PGS10001-Success IBPONDIUVY|BD2000045REC3909|SPMP9212546188|926885|... 3F119408481E50EA3375AFC39CD0A31000CF855AD3E707B570... Pondicherry University - Recruitment - Application... 2020-09-11 19:41:20 2020-09-11 19:39:09
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 4
4 34 2000034 200003401 1 BD2000034REC5033 2000 S 0 2020 IBPONDIUVY|BD2000034REC5033|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000034REC5033 SIOD9217760406 025723006660 00002000.0 IOD NA 03 INR DIRECT NA NA 0.00 13-09-2020 13:57:35 0300 NA NA NA NA NA NA NA NA NA Y IBPONDIUVY|BD2000034REC5033|SIOD9217760406|0257230... 61741C1267D0A1DBEE11C4C5B77A2841F4AF2988932BC8AC63... Pondicherry University - Recruitment - Application... 2020-09-13 13:53:13 2020-09-13 13:50:33
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 5
5 34 2000034 200003402 3 BD2000034REC5718 2000 S 0 2020 IBPONDIUVY|BD2000034REC5718|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000034REC5718 SIOD9217773501 025718006466 00002000.0 IOD NA 03 INR DIRECT NA NA 0.00 13-09-2020 14:03:39 0300 NA NA NA NA NA NA NA NA NA Y IBPONDIUVY|BD2000034REC5718|SIOD9217773501|0257180... C36F5D1ECEE9FC349F2148570C14B7558BDA3BB8E9AEA264B7... Pondicherry University - Recruitment - Application... 2020-09-13 13:59:03 2020-09-13 13:57:18
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 6
6 15 2000015 200001501 4 BD2000015REC4603 2000 F 0 2020 IBPONDIUVY|BD2000015REC4603|NA|2000|NA|NA|NA|INR|N... Pondicherry University - Recruitment - Application... 2020-09-14 16:46:03 2020-09-14 16:46:03
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 7
7 15 2000015 200001501 4 BD2000015REC4641 2000 S 0 2020 IBPONDIUVY|BD2000015REC4641|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000015REC4641 SBOI9221748822 102399404 00002000.0 BOI NA 01 INR DIRECT NA NA 17.70 14-09-2020 16:53:08 0300 NA NA NA NA NA NA NA NA NA Y IBPONDIUVY|BD2000015REC4641|SBOI9221748822|1023994... D59124648F3346A9F7411CDDAE97AFF7AE95F011453672BFBD... Pondicherry University - Recruitment - Application... 2020-09-14 16:48:49 2020-09-14 16:46:41
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 8
8 56 2000056 200005601 1 BD2000056REC0348 2000 S 0 2020 IBPONDIUVY|BD2000056REC0348|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000056REC0348 SIOD9222430622 025818015037 00002000.0 IOD NA 03 INR DIRECT NA NA 0.00 14-09-2020 20:10:11 0300 NA NA NA NA NA NA NA NA NA Y IBPONDIUVY|BD2000056REC0348|SIOD9222430622|0258180... 7BCEBF501EDD7953A6840C02D4354C6B34F5386BA5B8A564D2... Pondicherry University - Recruitment - Application... 2020-09-14 20:05:50 2020-09-14 20:03:48
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 9
9 56 2000056 200005602 3 BD2000056REC0729 2000 S 0 2020 IBPONDIUVY|BD2000056REC0729|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000056REC0729 SIOD9222439412 025818015100 00002000.0 IOD NA 03 INR DIRECT NA NA 0.00 14-09-2020 20:13:47 0300 NA NA NA NA NA NA NA NA NA Y IBPONDIUVY|BD2000056REC0729|SIOD9222439412|0258180... 73754C31E5CF5535315FF11B4E31F51F387A6B943A4565C705... Pondicherry University - Recruitment - Application... 2020-09-14 20:09:04 2020-09-14 20:07:29
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 10
10 51 2000051 200005101 4 BD2000051REC4601 2000 F 0 2020 IBPONDIUVY|BD2000051REC4601|NA|2000|NA|NA|NA|INR|N... Pondicherry University - Recruitment - Application... 2020-09-16 10:46:01 2020-09-16 10:46:01
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 11
11 51 2000051 200005101 4 BD2000051REC0247 2000 F 0 2020 IBPONDIUVY|BD2000051REC0247|NA|2000|NA|NA|NA|INR|N... Pondicherry University - Recruitment - Application... 2020-09-16 11:02:47 2020-09-16 11:02:47
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 12
12 51 2000051 200005101 4 BD2000051REC0330 2000 S 0 2020 IBPONDIUVY|BD2000051REC0330|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000051REC0330 SCNB9227518522 208511701990584 00002000.0 CNB NA 01 INR DIRECT NA NA 17.70 16-09-2020 11:09:51 0300 NA NA NA NA NA NA NA NA NA Y IBPONDIUVY|BD2000051REC0330|SCNB9227518522|2085117... 0C1437E34721FE0C3AC1C0CC79D7C013C76978E2C894A0856C... Pondicherry University - Recruitment - Application... 2020-09-16 11:05:26 2020-09-16 11:03:30
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 13
13 61 2000061 200006101 4 BD2000061REC0516 2000 S 0 2020 IBPONDIUVY|BD2000061REC0516|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000061REC0516 SUBI9227786046 126049848 00002000.0 UBI NA 01 INR DIRECT NA NA 17.70 16-09-2020 12:11:48 0300 NA NA NA NA NA NA NA NA NA Y IBPONDIUVY|BD2000061REC0516|SUBI9227786046|1260498... 175254442BBF9B5FA9BB7F334F6CCE09BB3301EA44AB5FA811... Pondicherry University - Recruitment - Application... 2020-09-16 12:09:41 2020-09-16 12:05:16
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 14
14 136 2000136 200013601 3 BD2000136REC3105 1000 S 0 2020 IBPONDIUVY|BD2000136REC3105|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000136REC3105 SHMP9250447166 023099 1000.00 HMP 433587 02 INR DIRECT 05-NA NA 00000011.00 22-09-2020 18:40:00 0300 NA NA NA NA NA NA NA NA NA PGS10001-Success IBPONDIUVY|BD2000136REC3105|SHMP9250447166|023099|... E3F476511C1792FD523ABB29ECC802E3AB84663304FE2BE1A7... Pondicherry University - Recruitment - Application... 2020-09-22 18:34:17 2020-09-22 18:31:05
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 15
15 29 2000029 200002901 3 BD2000029REC1723 2000 S 0 2020 IBPONDIUVY|BD2000029REC1723|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000029REC1723 SCBI9251050938 756792711 00002000.0 CBI NA 01 INR DIRECT NA NA 17.70 22-09-2020 21:24:41 0300 NA NA NA NA NA NA NA NA NA Y IBPONDIUVY|BD2000029REC1723|SCBI9251050938|7567927... DAFD24755C1D1657434A9A95CF2265922EE3EEFB986FC54DD9... Pondicherry University - Recruitment - Application... 2020-09-22 21:21:14 2020-09-22 21:17:23
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 16
16 115 2000115 200011501 1 BD2000115REC5300 2000 S 0 2020 IBPONDIUVY|BD2000115REC5300|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000115REC5300 SUR29251705572 026707937936 2000.00 UR2 508944 03 INR RDDIRECT NA-443667 NA 00000000.00 23-09-2020 07:00:44 0300 NA NA NA NA NA NA NA NA NA PGS10001-Success IBPONDIUVY|BD2000115REC5300|SUR29251705572|0267079... 86E545869F76D47CD838E3C4D57A955BDF7C8845CEC40344F8... Pondicherry University - Recruitment - Application... 2020-09-23 06:54:55 2020-09-23 06:53:00
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 17
17 115 2000115 200011502 3 BD2000115REC5855 2000 S 0 2020 IBPONDIUVY|BD2000115REC5855|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000115REC5855 SUR29251700546 026707938643 2000.00 UR2 508944 03 INR RDDIRECT NA-564367 NA 00000000.00 23-09-2020 07:05:56 0300 NA NA NA NA NA NA NA NA NA PGS10001-Success IBPONDIUVY|BD2000115REC5855|SUR29251700546|0267079... DDD2379C1375C0A6D29726D1165596E036CE1068E6F0B2940C... Pondicherry University - Recruitment - Application... 2020-09-23 07:00:03 2020-09-23 06:58:55
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 18
18 36 2000036 200003601 2 BD2000036REC1714 2000 F 0 2020 IBPONDIUVY|BD2000036REC1714|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000036REC1714 NA NA 2017.70 SBI BILL_PUNIV NA INR DIRECT R ibpondiuvy NA 26-09-2020 11:25:10 0002 F NA NA NA NA NA NA NA ERR113 Sorry.  We were unable to process your transaction... IBPONDIUVY|BD2000036REC1714|NA|NA|2017.70|SBI|BILL... 9080DF8AFE099FC00B0076EAD37B2E4460AC6AEB120D94784D... Pondicherry University - Recruitment - Application... 2020-09-26 11:18:51 2020-09-26 11:17:14
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 19
19 36 2000036 200003601 2 BD2000036REC2211 2000 S 0 2020 IBPONDIUVY|BD2000036REC2211|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000036REC2211 SSBI9262969200 IGAJMHNZJ3 00002000.0 SBI NA 01 INR DIRECT NA NA 17.70 26-09-2020 11:28:41 0300 NA NA NA NA NA NA NA NA NA Completed successfully. IBPONDIUVY|BD2000036REC2211|SSBI9262969200|IGAJMHN... 391E58B154D2C3C3C8C39A06464950779A6F48AB2EC8C89FDA... Pondicherry University - Recruitment - Application... 2020-09-26 11:25:02 2020-09-26 11:22:11
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 20
20 217 2000217 200021701 1 BD2000217REC2030 2000 S 0 2020 IBPONDIUVY|BD2000217REC2030|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000217REC2030 SHMP9264057334 087486 2000.00 HMP 463917 02 INR DIRECT 05-NA NA 00000022.00 26-09-2020 16:27:38 0300 NA NA NA NA NA NA NA NA NA PGS10001-Success IBPONDIUVY|BD2000217REC2030|SHMP9264057334|087486|... F67E7917E44297545581806ABD77AF91A66EF4B0BA8A312D5C... Pondicherry University - Recruitment - Application... 2020-09-26 16:21:37 2020-09-26 16:20:30
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 21
21 217 2000217 200021702 3 BD2000217REC2527 2000 F 0 2020 IBPONDIUVY|BD2000217REC2527|NA|2000|NA|NA|NA|INR|N... Pondicherry University - Recruitment - Application... 2020-09-26 16:25:27 2020-09-26 16:25:27
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 22
22 217 2000217 200021702 3 BD2000217REC2545 2000 S 0 2020 IBPONDIUVY|BD2000217REC2545|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000217REC2545 SHMP9264063338 097370 2000.00 HMP 463917 02 INR DIRECT 05-NA NA 00000022.00 26-09-2020 16:32:45 0300 NA NA NA NA NA NA NA NA NA PGS10001-Success IBPONDIUVY|BD2000217REC2545|SHMP9264063338|097370|... 8E511836135D9B5A5519DD34A1474A9F3AAEA799671E2F0CB9... Pondicherry University - Recruitment - Application... 2020-09-26 16:26:45 2020-09-26 16:25:45
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 23
23 198 2000198 200019801 1 BD2000198REC2142 2000 S 0 2020 IBPONDIUVY|BD2000198REC2142|NA|2000|NA|NA|NA|INR|N... IBPONDIUVY BD2000198REC2142 SHMP9265165263 047384 2000.00 HMP 437748 02 INR DIRECT 05-NA NA 00000022.00 26-09-2020 22:28:40 0300 NA NA NA NA NA NA NA NA NA PGS10001-Success IBPONDIUVY|BD2000198REC2142|SHMP9265165263|047384|... CBAB06332EECE18485D6F609619CC237B5EB635EF4D196DFA1... Pondicherry University - Recruitment - Application... 2020-09-26 22:22:57 2020-09-26 22:21:42
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 24
24 73 2000073 200007301 1 BD2000073REC3132 1000 S 0 2020 IBPONDIUVY|BD2000073REC3132|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000073REC3132 SSBI9266101174 IGAJMMWOH5 00001000.0 SBI NA 01 INR DIRECT NA NA 17.70 27-09-2020 11:38:04 0300 NA NA NA NA NA NA NA NA NA Completed successfully. IBPONDIUVY|BD2000073REC3132|SSBI9266101174|IGAJMMW... 843D25274A78401C0F666049C4BA99EDDB12BE640EC304425E... Pondicherry University - Recruitment - Application... 2020-09-27 11:32:49 2020-09-27 11:31:32
Edit EditCopy CopyDelete Delete
DELETE FROM `payment_bill_desk` WHERE `payment_bill_desk`.`id` = 25
25 229 2000229 200022901 1 BD2000229REC4311 1000 S 0 2020 IBPONDIUVY|BD2000229REC4311|NA|1000|NA|NA|NA|INR|N... IBPONDIUVY BD2000229REC4311 SUR29267476247 027119704768 1000.00 UR2 652171 03 INR RDDIRECT NA-704768 NA 00000000.00 27-09-2020 19:51:38 0300 NA NA NA NA NA NA NA NA NA PGS10001-Success IBPONDIUVY|BD2000229REC4311|SUR29267476247|0271197... F9D2A02F707ECE8323B975613CDB0CE0F281D7A8B05A1E6812... Pondicherry University - Recruitment - Application... 2020-09-27 19:46:02 2020-09-27 19:43:11
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.