119.148.37.236 / localhost / proxima_database_two / lcinfobackup

There are no favorite tables.

New
information_schema
mysql
performance_schema
phpmyadmin
proxima_database
- proxima_database
- proxima_database_two
sajola_mms
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 :

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

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 (3486 total, Query took 0.0040 seconds.) [lcpivalidity: -15... - 15...]

SELECT * FROM `lcinfobackup` ORDER BY `lcpivalidity` ASC

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

Filter rows:

			lcaid	lcid	lcno	lcdate	lamentno	lamentdate	lcopenbid	lcnegobid	shipdate	lcexpdate	lcincvalue	lcvalue	lcdecvalue	lcpivalidity 1	lcdelivery	desc1	lcimage	lcamimage
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 24	24	162	019512040714	2012-08-29	NULL	NULL	81	13	2012-09-30	2012-10-14	NULL	183600.00	NULL	-15	0	<p> NONE</p>	NULL	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 307	307	162	019512040714	2012-08-29	02	2012-10-21	81	13	2012-11-29	2012-12-13	181746.00	183600.00	NULL	-15	0	<p> NONE</p>	NULL	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 126	126	162	019512040714	2012-08-29	01,02	2012-10-21	81	13	2012-11-29	2012-12-13	431996.02	183600.00	NULL	-15	0	<p> NONE</p>	NULL	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 1	1	165	033212040153	2012-05-27	NULL	NULL	87	12	2012-06-15	2012-06-25	NULL	34692.00	NULL	-2	0	<p> NONE</p>	NULL	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 1624	1624	3067	175914120125	2014-12-22	NULL	NULL	200	12	2014-12-23	2014-12-25	NULL	23786.95	NULL	3	0	<p>NONE</p>	2osleegm.pdf	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 1133	1133	2361	297314040158	2014-05-20	NULL	NULL	189	12	2014-05-20	2014-05-30	NULL	5952.00	NULL	10	0	<p>NONE </p>	mk14m35j.pdf	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 1047	1047	2268	089914040252	2014-04-17	NULL	NULL	212	12	2014-04-17	2014-04-28	NULL	7358.40	NULL	11	0	<p>NONE </p>	jw1qkb1z.pdf	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 832	832	1877	121313040245	2013-11-24	NULL	NULL	128	12	2013-11-30	2013-12-05	NULL	9170.00	NULL	11	0	<p>NONE </p>	z6mozyuu.pdf	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 3050	3050	5115	175916120128	2016-05-19	NULL	NULL	200	12	2016-05-20	2016-05-30	0.00	47655.00	0.00	11	0	<p>NONE</p>	hjqdxe90.pdf	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 1613	1613	3102	229114040111	2014-10-29	NULL	NULL	253	12	2014-10-31	2014-11-10	NULL	6800.00	NULL	12	0	<p>NONE</p>	d4xqrivs.pdf	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 1591	1591	3070	303514042280	2014-11-27	NULL	NULL	58	12	2014-11-30	2014-12-10	NULL	4535.50	NULL	13	0	<p>NONE</p>	9r8tuma4.pdf	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 1935	1935	3436	269015040017	2015-03-25	NULL	NULL	241	12	2015-03-31	2015-04-07	NULL	9440.00	NULL	13	0	<p>NONE</p>	4z4hzbz7.pdf	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 6	6	173	BBCDAK205749	2012-07-05	NULL	NULL	77	12	2012-07-12	2012-07-19	NULL	18976.25	NULL	14	0	<p> NONE</p>	NULL	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 7	7	173	BBCDAK205749	2012-07-05	1	2012-07-18	77	12	2012-07-12	2012-07-19	15861.00	18976.25	NULL	14	0	<p> NONE</p>	NULL	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 2927	2927	4920	075116041102	2016-03-27	NULL	NULL	55	12	2016-04-05	2016-04-10	0.00	37356.89	0.00	14	0	<p>NONE</p>	e5lxteac.pdf	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 2167	2167	3847	174115042591	2015-06-16	NULL	NULL	62	12	2015-06-16	2015-06-30	NULL	10000.00	NULL	14	0	<p>NONE</p>	rm012bzw.pdf	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 1942	1942	3439	0000194615040411	2015-03-25	NULL	NULL	156	12	2015-03-30	2015-04-08	NULL	35794.00	NULL	14	0	<p>NONE</p>	dzijc9zg.pdf	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 2218	2218	3847	174115042591	2015-06-16	01	2015-07-28	62	12	2015-06-16	2015-06-30	NULL	10000.00	NULL	14	0	<p>NONE</p>	rm012bzw.pdf	./images/lcamimage/sgs4oeu2.pdf
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 23	23	257	296212040621	2012-08-30	NULL	NULL	85	13	2012-08-30	2012-09-14	NULL	93477.56	NULL	15	0	<p> NONE</p>	NULL	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 39	39	339	215512040167	2012-06-11	NULL	NULL	119	13	2012-06-20	2012-06-26	NULL	15960.00	NULL	15	0	<p> NONE</p>	NULL	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 2345	2345	3774	0000195515040905	2015-07-15	01	2015-06-29	47	12	2015-07-30	2015-08-14	1828.20	14025.00	NULL	15	0	<p>NONE</p>	j4wcqr4u.pdf	./images/lcamimage/9qhnezm2.pdf
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 2346	2346	3774	0000195515040905	2015-07-15	02	2015-09-07	47	12	2015-07-30	2015-08-14	763.60	14025.00	NULL	15	0	<p>NONE</p>	j4wcqr4u.pdf	./images/lcamimage/rscn0k7s.pdf
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 2103	2103	3738	075115041054	2015-06-15	NULL	NULL	55	12	2015-06-25	2015-06-30	NULL	14645.40	NULL	15	0	<p>NONE</p>	w0nlef5f.pdf	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 2116	2116	3774	0000195515040905	2015-07-15	NULL	NULL	47	12	2015-07-15	2015-07-30	NULL	14025.00	NULL	15	0	<p>NONE</p>	j4wcqr4u.pdf	NULL
Edit	Copy	Delete DELETE FROM lcinfobackup WHERE `lcinfobackup`.`lcaid` = 1609	1609	3065	101314041425	2014-12-21	NULL	NULL	20	12	2014-12-25	2015-01-05	NULL	47778.30	NULL	15	0	<p>NONE</p>	4npatxli.pdf	NULL

Check all With selected:

Filter rows:

Query results operations

Copy to clipboard

Export

Display chart

Create view