www.schloemer.biz / rdbms.strato.de / DB685940 / mein_verein-bak

Navigation panel
Navigation tree
Servers
Databases
Tables

Navigation panel

Customize appearance of the 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.

Navigation tree

Customize the 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

Servers

Servers display options.

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

Databases display options.

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

Tables

Tables display options.

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-

Server: rdbms.strato.de »

Database: DB685940 »

Table: mein_verein-bak

Click on the bar to scroll to top of page

Press Ctrl+Enter to execute query

Collapse Expand Show trace Hide trace Time taken

No bookmarks

Label: Target database: Share this bookmark

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 Bookmark Query failed Database Queried time

Browse mode

Browse mode

Customize 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

Current selection does not contain a unique column. Grid edit, checkbox, Edit, Copy and Delete features are not available.

Showing rows 0 - 24 (221 total, Query took 0.0026 seconds.)

SELECT * FROM `mein_verein-bak`

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

Filter rows:

DBINDEX	ART	NUMMER	ANREDE	TITEL	NACHNAMEFIRMA	VORNAME	ZUSATZ	STRASSE	LAND	PLZ	ORT	TELEFON1	TELEFON2	FAX	MOBILTELEFON	EMAIL	WEBSEITE	DEBITORENNUMMER	ANMERKUNGEN	INDIVIDUELL1	INDIVIDUELL2	INDIVIDUELL3	INDIVIDUELL4	INDIVIDUELL5	GEBURTSTAG	FAMILIENSTATUS	EINTRITTSDATUM	AUSTRITTSDATUM	AKTIVVON	AKTIVBIS	ANSPRECHPARTNER_ANREDE	ANSPRECHPARTNER_TITEL	ANSPRECHPARTNER_NACHNAME	ANSPRECHPARTNER_VORNAME	ANSPRECHPARTNER_POSITION	ANSPRECHPARTNER_TELEFON1	ANSPRECHPARTNER_TELEFON2	ANSPRECHPARTNER_FAX	ANSPRECHPARTNER_MOBILTELEFON	ANSPRECHPARTNER_EMAIL	FUNKTION
951	1	1	Herr		Ammon	Adolf		Kaulberg 2	D	96184	Rentweinsdorf	88 51										X	VS = verstorben		1921-06-13	2	1988-01-27	2006-12-12	0000-00-00	0000-00-00											NULL
952	1	2	Herr		Andres	Willi		Sendelbach 7	D	96184	Rentweinsdorf	89 21				willi.andres@ruv.de						X	MP = passiv		1950-03-12	2	1988-01-27	0000-00-00	0000-00-00	0000-00-00											NULL
953	1	3	Herr		Appelmann	Ludwig		Kappelleite 1	D	96184	Rentweinsdorf	10 47										X	VS = verstorben		1926-12-18	2	1988-01-27	2011-01-24	0000-00-00	0000-00-00											NULL
954	1	4	Herr		Bauer	Michael		Hauptstr. 11	D	96184	Rentweinsdorf	10 64										X	VG = gekündigt		1938-01-02	2	1988-01-27	2012-12-31	0000-00-00	0000-00-00											NULL
955	1	5	Frau		Bühl	Bärbel		Sommerleite 15	D	96184	Rentweinsdorf	66 94										X	VG = gekündigt		1965-07-27	0	1988-01-27	2007-09-18	0000-00-00	0000-00-00											NULL
956	1	6	Herr		Bühl	Gerhard		Sommerleite 15	D	96184	Rentweinsdorf	66 94										X	VG = gekündigt		1964-03-08	0	1988-01-27	2007-09-18	0000-00-00	0000-00-00											NULL
957	1	7	Herr		Dekarski	Hans-Jürgen		Treinfeld 28	D	96184	Rentweinsdorf	84 37									KSV 1	X	MA = aktiv		1942-12-25	2	1988-01-27	0000-00-00	0000-00-00	0000-00-00											1. Vorstand
1086	1	137	Frau		Diringer	Nicole		Kaulberg 7a	D	96184	Rentweinsdorf	86 93											MP = passiv		1997-06-03	1	2009-11-20	2013-12-31	0000-00-00	0000-00-00											NULL
961	1	11	Herr		Gagel	Karl		Türkei 10	D	96184	Rentweinsdorf	41 22										X	VG = gekündigt		1934-02-28	2	1988-01-27	2010-04-01	0000-00-00	0000-00-00											NULL
962	1	12	Herr		Genslein	Arnold		Sommerleite 13	D	96184	Rentweinsdorf	16 23										X	MP = passiv		1956-05-07	2	1988-01-27	0000-00-00	0000-00-00	0000-00-00											NULL
963	1	13	Frau		Genslein	Marion		Sommerleite 13	D	96184	Rentweinsdorf	16 23										X	MP = passiv		1961-03-26	2	1988-01-27	0000-00-00	0000-00-00	0000-00-00											NULL
964	1	14	Herr		Hellwig	Werner		Sendelbach 8	D	96184	Rentweinsdorf	87 99										X	EH = Ehrenmitglied		1938-07-18	2	1988-01-27	0000-00-00	0000-00-00	0000-00-00											NULL
965	1	15	Herr		Hetzer	Reinhard		Friedrich-Nembach-Str. 5	D	96184	Rentweinsdorf	68 74										X	VG = gekündigt		1970-08-29	2	1988-01-27	2009-06-29	0000-00-00	0000-00-00											NULL
966	1	16	Herr		Heyer	Thomas		Albersdorf 27	D	96106	Ebern	0 95 34 - 4 32										X	MP = passiv		1960-10-04	2	1988-01-27	0000-00-00	0000-00-00	0000-00-00											NULL
967	1	17	Herr		Horn	Siegfried		Treinfeld 19	D	96184	Rentweinsdorf	10 74										X	VG = gekündigt		1945-05-25	2	1988-01-27	2008-07-03	0000-00-00	0000-00-00											NULL
1108	1	157	Herr		Hellwig	Thomas		Sendelbach 8	D	96184	Rentweinsdorf											X	VG = gekündigt		1965-03-01	2	1988-01-27	1996-12-31	0000-00-00	0000-00-00											NULL
1101	1	151	Herr		Fürth	Dieter		Eisgrube 4	D	96184	Rentweinsdorf												VG = gekündigt		0000-00-00	2	1996-04-09	2003-11-06	0000-00-00	0000-00-00											NULL
968	1	18	Herr		Horn	Stefan		Treinfeld 19	D	96184	Rentweinsdorf	10 74										X	MP = passiv		1967-10-16	1	1988-01-27	0000-00-00	0000-00-00	0000-00-00											NULL
969	1	19	Herr		Hübner	Marcus		Hauptstr. 12	D	97496	Burgpreppach	0 95 34 - 17 31 88										X	VG = gekündigt		1974-02-08	2	1988-01-27	2010-12-31	0000-00-00	0000-00-00											NULL
970	1	20	Frau		Hübner	Melanie		Treinfeld 50	D	96184	Rentweinsdorf	89 48										X	VG = gekündigt		1977-08-10	1	1988-01-27	2010-12-31	0000-00-00	0000-00-00											NULL
971	1	21	Herr		Hübner	Rudolf		Treinfeld 50	D	96184	Rentweinsdorf	87 29										X	VG = gekündigt		1953-06-05	2	1988-01-27	2010-12-31	0000-00-00	0000-00-00											NULL
972	1	22	Herr		Hufnagel	Wolfgang		Pfortenklinge 34	D	96184	Rentweinsdorf	84 54										X	MP = passiv		1953-09-18	2	1988-01-27	0000-00-00	0000-00-00	0000-00-00											NULL
973	1	23	Herr		Jakob	Adolf		Hauptstr. 25	D	96184	Rentweinsdorf											X	VS = verstorben		1936-10-31	4	1988-01-27	2010-02-02	0000-00-00	0000-00-00											NULL
974	1	24	Frau		Kaim	Irmgard		Lind 21	D	96184	Rentweinsdorf	88 19										X	MP = passiv		1939-03-05	2	1988-01-27	2013-12-31	0000-00-00	0000-00-00											NULL
975	1	25	Frau		Klopf	Olga		Kaulberg 16	D	96184	Rentweinsdorf	83 46										X	VS = verstorben		1920-11-09	4	1988-01-27	2011-09-11	0000-00-00	0000-00-00											NULL

Filter rows:

Query results operations