gambia.feste-ip.net / 127.0.0.1 / axiuss40_africa_charity_program / banks_for_check

There are no favorite tables.

New
axiuss40_africa
information_schema
mysql
performance_schema
task_manager
- task_manager
- task_manager_staging
test

Customize appearance of the navigation panel.

Navigation panel

Show databases navigation as tree In the navigation panel, replaces the database tree with a selector
Link with main panel Link with main panel by highlighting the current database or table.
Display logo Show logo in navigation panel.
Logo link URL URL where logo in the navigation panel will point to.
Logo link target Open the linked page in the main window (`main`) or in a new one (`new`).
Enable highlighting Highlight server under the mouse cursor.
Maximum items on first level The number of items that can be displayed on each page on the first level of the navigation tree.
Minimum number of items to display the filter box Defines the minimum number of items (tables, views, routines and events) to display a filter box.
Recently used tables Maximum number of recently used tables; set 0 to disable.
Favorite tables Maximum number of favorite tables; set 0 to disable.
Navigation panel width Set to 0 to collapse navigation panel.

Customize the navigation tree.

Navigation tree

Maximum items in branch The number of items that can be displayed on each page of the navigation tree.
Group items in the tree Group items in the navigation tree (determined by the separator defined in the Databases and Tables tabs above).
Enable navigation tree expansion Whether to offer the possibility of tree expansion in the navigation panel.
Show tables in tree Whether to show tables under database in the navigation tree
Show views in tree Whether to show views under database in the navigation tree
Show functions in tree Whether to show functions under database in the navigation tree
Show procedures in tree Whether to show procedures under database in the navigation tree
Show events in tree Whether to show events under database in the navigation tree
Expand single database Whether to expand single database in the navigation tree automatically.

Servers display options.

Servers

Display servers selection Display server choice at the top of the navigation panel.
Display servers as a list Show server listing as a list instead of a drop down.

Databases display options.

Databases

Minimum number of databases to display the database filter box
Database tree separator String that separates databases into different tree levels.

Tables display options.

Tables

Target for quick access icon
Target for second quick access icon
Table tree separator String that separates tables into different tree levels.
Maximum table tree depth

Drop files here

SQL upload ( 0 ) x -

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken :

Always expand query messages
Show query history at start
Show current browsing query
Execute queries on Enter and insert new line with Shift+Enter. To make this permanent, view settings.
Switch to dark theme

Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :

Browse mode

Customize browse mode.

Browse mode

Table navigation bar Use only icons, only text or both.
How to display various action links Use only icons, only text or both.
Allow to display all the rows Whether a user should be displayed a "show all (rows)" button.
Maximum number of rows to display Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Default sorting order `SMART` - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Highlight pointer Highlight row pointed by the mouse cursor.
Row marker Highlight selected rows.
Grid editing: trigger action
Grid editing: save all edited cells at once
Repeat headers Repeat the headers every X cells, `0` deactivates this feature.
Limit column characters Maximum number of characters shown in any non-numeric column on browse view.
Where to show the table row links These are Edit, Copy and Delete links.
Show row links anyway Whether to show row links even in the absence of a unique key.
Primary key default sort order Default sort order for tables with a primary key.
Remember table's sorting When browsing tables, the sorting of each table is remembered.
Relational display For display Options

Showing rows 0 - 24 (3547 total, Query took 0.0025 seconds.)

SELECT * FROM `banks_for_check`

[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]

Filter rows:

			id	BLZ	Name	Address	Name1	BIC	status 0- Deactivate 1- Activate	deleted 0- No 1- Yes	addedOn	addedBy	modifiedBy	modifiedOn
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 16	16	10000000	Bundesbank	10591 Berlin	BBk Berlin	MARKDEF1100	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 17	17	10010010	Postbank Ndl der Deutsche Bank	10559 Berlin	Postbank Ndl Deutsche Bank	PBNKDEFFXXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 18	18	10010123	OLINDA Zweigniederlassung Deutschland	10785 Berlin	Olinda, Berlin	QNTODEB2XXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 19	19	10010300	Klarna Bank German Branch	10115 Berlin	Klarna Bank, Berlin	KLRNDEBEXXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 20	20	10010424	Aareal Bank	10666 Berlin	Aareal Bank	AARBDE5W100	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 21	21	10010500	Afone Paiement	10719 Berlin	Afone Paiement, Berlin	AFOPDEB2XXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 22	22	10010700	Financiere des Paiements Electroniques NL Deutschl...	10719 Berlin	FPE Deutschland	FPEGDEB2XXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 23	23	10011001	N26 Bank	10179 Berlin	N26 Bank Berlin	NTSBDEB1XXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 24	24	10017997	Holvi Payment Services Zweigniederlassung Deutschl...	12059 Berlin	Holvi - Berlin	HOLVDEB1XXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 25	25	10020200	BHF-BANK	10117 Berlin	BHF-BANK Berlin	BHFBDEFF100	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 26	26	10020500	Bank für Sozialwirtschaft	10178 Berlin	Bank für Sozialwirtschaft	BFSWDE33BER	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 27	27	10020510	Bank für Sozialwirtschaft	10178 Berlin	Sozialbank Berlin	BFSWDE33BER	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 28	28	10020520	Bank für Sozialwirtschaft	10178 Berlin	Sozialbank Berlin	BFSWDE33BER	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 29	29	10020890	UniCredit Bank - HypoVereinsbank	10896 Berlin	UniCredit Bank-HypoVereinbk	HYVEDEMM488	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 34	34	10030200	Berlin Hyp	10787 Berlin	Berlin Hyp	BHYPDEB2XXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 35	35	10030400	ABK Allgemeine Beamten Bank	10115 Berlin	ABK Bank Berlin	ABKBDEB1XXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 36	36	10030500	M.M. Warburg & Co (vormals Bankhaus Löbbecke)	20095 Hamburg	M.M. Warburg (Löbbecke)	LOEBDEBBXXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 37	37	10030600	North Channel Bank	55118 Mainz	North Channel Bank Mainz	GENODEF1OGK	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 38	38	10030700	Eurocity Bank	60311 Frankfurt am Main	Eurocity Bank	DLGHDEB1XXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 40	40	10030730	Eurocity Bank Gf GAA	60311 Frankfurt am Main	Eurocity Bank Gf GAA	DLGHDEB1XXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 41	41	10031000	EIS Einlagensicherungsbank	10178 Berlin	EIS Bank Berlin	EIEGDEB1XXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 42	42	10033300	Santander Consumer Bank	10439 Berlin	Santander Bank Berlin	SCFBDE33XXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 43	43	10040000	Commerzbank, Filiale Berlin 1	10891 Berlin	Commerzbank Fil. Berlin 1	COBADEBBXXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 44	44	10040005	Commerzbank, Filiale Berlin 3	10891 Berlin	Commerzbank Fil. Berlin 3	COBADEBBXXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58
Edit	Copy	Delete DELETE FROM banks_for_check WHERE `banks_for_check`.`id` = 45	45	10040010	Commerzbank, CC SP	10877 Berlin	Commerzbank CC SP, Berlin	COBADEFFXXX	1	0	0000-00-00 00:00:00	0	0	2024-12-27 14:22:58

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view