www.kikkoman.mx / 127.0.0.1 / kikko / document_table

Recent`ksuiso`.`broker`
`ksuiso`.`customer`
`mysql`.`transaction_registry`
`mysql`.`innodb_index_stats`
`information_schema`.`INNODB_SYS_TABLES`
`ksudms`.`broker2`
`ksutds`.`non_gmo_items`
`information_schema`.`INNODB_SYS_VIRTUAL`
`ksutds`.`branches_bk`
`ksutds`.`dc_ing_bk`
FavoritesThere are no favorite tables.
New
cm9vdA==.ZG1zX2Rldg==cm9vdA==.ZG1zX2Rldg==0
dms_dev
cm9vdA==.aW5mb3JtYXRpb25fc2NoZW1hcm9vdA==.aW5mb3JtYXRpb25fc2NoZW1h0
information_schema
cm9vdA==.a2lra28=cm9vdA==.a2lra28=0
kikko
cm9vdA==.a2lra29tYW5teA==cm9vdA==.a2lra29tYW5teA==0
kikkomanmx
cm9vdA==.a3N1ZG1zcm9vdA==.a3N1ZG1z0
ksudms
cm9vdA==.a3N1aXNvcm9vdA==.a3N1aXNv0
ksuiso
cm9vdA==.a3N1c3Nncm9vdA==.a3N1c3Nn0
ksussg
cm9vdA==.a3N1dGRzcm9vdA==.a3N1dGRz0
ksutds
cm9vdA==.bXlzcWw=cm9vdA==.bXlzcWw=0
mysql
cm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1hcm9vdA==.cGVyZm9ybWFuY2Vfc2NoZW1h0
performance_schema
cm9vdA==.cGhwbXlhZG1pbg==cm9vdA==.cGhwbXlhZG1pbg==0
phpmyadmin
cm9vdA==.cmVhZG1lX3RvX3JlY292ZXJfc3o=cm9vdA==.cmVhZG1lX3RvX3JlY292ZXJfc3o=0
readme_to_recover_sz
cm9vdA==.c2VjdXJlZF9pcA==cm9vdA==.c2VjdXJlZF9pcA==0
secured_ip
cm9vdA==.c3Rtcw==cm9vdA==.c3Rtcw==0
stms
cm9vdA==.dGVzdA==cm9vdA==.dGVzdA==0
test

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: 127.0.0.1 »

Database: kikko »

Table: document_table

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

Showing rows 0 - 24 (3432 total, Query took 0.0047 seconds.) [doc_table_id: 35... - 120...]

SELECT * FROM `document_table` ORDER BY `doc_table_id` ASC

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

Filter rows:

			doc_table_id 1	user_level	kcc	ref_kcc	productcode	doc_name	doc_description	doc_keyword	created_user	created_date	expire_date	mod_date	doc_file_name	upload_date	status 2=pending
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 35	35	3	110106		00050	110106.00050.3D.tiff	12 5 fl oz Soy Sauce 3D Image	00050 5 OZ SOY SAUCE 3D Image	miwa	2008-02-07	2029-12-31	2008-02-07	110106.00050.3D.tiff	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 42	42	3	110108	6c01	00160	110108.00160.SoySc_ 1Gal.specs.pdf	Soy Sauce Specifications	Soy Sauce SPECIFICATIONS SPECS 00160	miwa	2008-03-06	2029-12-31	2013-09-17	110108.00160.SoySc_ 1Gal.specs.pdf	2013-09-18	2
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 46	46	3	110111		00050, 00070, 00078, 00090	110111. Soy Sauce Allergen Main Letter_1.pdf	Soy Sauce Allergen Letter	Soy Sauce Allergen Letter	miwa	2008-03-06	2029-12-31	2013-09-17	110111. Soy Sauce Allergen Main Letter_1.pdf	2013-09-18	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 65	65	3	110207		00101, 00105, 00107, 00110	110207. LessSodiumSoySauce.3-05.nut.pdf	Less Sodium Soy Sauce Nutrition Facts	Less Sodium Soy Sauce nutrition nutritionals facts	miwa	2008-03-06	2029-12-31	2008-03-06	110207. LessSodiumSoySauce.3-05.nut.pdf	2008-03-06	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 95	95	3	110304		01504, 01500, 01512, 01508	110304.Q&E_marinades.pdf	Q&E Sales Sheet	Q&E sell sales Sheet 01504 01500 01512 01508 Roast...	miwa	2008-02-07	2029-12-31	2008-02-07	110304.Q&E_marinades.pdf	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 101	101	3	110306		01011	110306.01011.3D.tiff	12 5 fl oz Teriyaki Sauce 3D Image	01011 5 OZ TERIYAKI SAUCE 3D Image	miwa	2008-02-07	2029-12-31	2008-02-07	110306.01011.3D.tiff	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 102	102	3	110306		01022	110306.01022.3D.tiff	12 10 fl oz Teriyaki Sauce 3D Image	01022 10 OZ TERIYAKI SAUCE 3D Image	miwa	2008-02-07	2029-12-31	2008-02-07	110306.01022.3D.tiff	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 103	103	3	110306		01030	110306.01030.3D.tif	12 15 fl oz Teriyaki Sauce 3D Image	01030 15 OZ TERIYAKI SAUCE 3D Image	miwa	2008-02-07	2029-12-31	2008-02-07	110306.01030.3D.tif	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 104	104	3	110306		01033	110306.01033.3D.tiff	12 20 fl oz Teriyaki Sauce 3D Image	01033 20 OZ TERIYAKI SAUCE 3D Image	miwa	2008-02-07	2029-12-31	2008-02-07	110306.01033.3D.tiff	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 105	105	3	110306		01035	110306.01035.3D.tiff	9 40 fl oz Teriyaki Sauce 3D Image	01035 40 OZ TERIYAKI SAUCE 3D Image	miwa	2008-02-07	2029-12-31	2008-02-07	110306.01035.3D.tiff	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 106	106	3	110306		01040	110306.01040.3D.tiff	12 10 fl oz Less Sodium Teriyaki Sauce 3D Image	01040 10 OZ LESS SODIUM TERIYAKI SAUCE (LITE TERI)...	miwa	2008-02-07	2029-12-31	2008-02-07	110306.01040.3D.tiff	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 107	107	3	110306		01052	110306.01052.3D.tif	12 10 fl oz Roasted Garlic Teriyaki Sauce 3D Image	01052 10 OZ ROASTED GARLIC TERIYAKI SAUCE 3D Image	miwa	2008-02-07	2029-12-31	2008-02-07	110306.01052.3D.tif	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 108	108	3	110306		01054	110306.01054.3D.tiff	12 15 fl oz Roasted Garlic Teriyaki Sauce 3D Image	01054 15 OZ ROASTED GARLIC TERIYAKI SAUCE 3D Image	miwa	2008-02-07	2029-12-31	2008-02-07	110306.01054.3D.tiff	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 109	109	3	110306		01056	110306.01056.3D.tiff	12 20 fl oz Roasted Garlic Teriyaki Sauce 3D Image	01056 20 OZ ROASTED GARLIC TERIYAKI SAUCE 3D Image	miwa	2008-02-07	2029-12-31	2008-02-07	110306.01056.3D.tiff	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 110	110	3	110306		01110	110306.01110.3D.tif	12 12 wt oz Teriyaki B&G 3D Image	01110 12 OZ TERIYAKI B&G 3D Image	miwa	2008-02-07	2029-12-31	2008-02-07	110306.01110.3D.tif	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 111	111	3	110306		01185	110306.01185.3D.tif	12 12.8 wt oz Teriyaki B&G H&P 3D Image	01185 12.8 OZ TERIYAKI B&G H&P 3D Image	miwa	2008-02-07	2029-12-31	2008-02-07	110306.01185.3D.tif	2008-02-07	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 112	112	3	110307		01040	110307. 01040.nut.pdf	12 10 fl oz Less Sodium Teriyaki Sauce Nutrition F...	01040 Less Sodium Teriyaki M&S nutrition nutrition...	miwa	2008-03-06	2029-12-31	2008-03-06	110307. 01040.nut.pdf	2008-03-06	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 113	113	3	110307		01500	110307. 01500 Q&E_Toast_Ses.nut.pdf	12 14 wt oz Q&E Toasted Sesame Teriyaki Nutrition ...	01500 Q&E Toasted Sesame nutrition nutritionals fa...	miwa	2008-03-06	2029-12-31	2013-09-12	110307. 01500 Q&E_Toast_Ses.nut.pdf	2013-09-12	0
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 114	114	3	110307		01504	110307. 01504.nut.pdf	12 14 wt oz Q&E Roasted Garlic & Herb Nutrition Fa...	01504 Q&E RG&H nutrition nutritionals facts	miwa	2008-03-06	2029-12-31	2008-03-06	110307. 01504.nut.pdf	2008-03-06	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 115	115	3	110307		01508	110307. 01508.nut.pdf	12 14 wt oz Q&E Gourmet Teriyaki Nutrition Facts	01508 Q&E Gourmet Teriyaki nutrition nutritionals ...	miwa	2008-03-06	2029-12-31	2008-03-06	110307. 01508.nut.pdf	2008-03-06	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 116	116	3	110307		01512	110307. 01512.3-05.nut.pdf	12 14 wt oz Q&E Honey & Mustard Teriyaki Nutrition...	01512 Honey & Mustard nutrition nutritionals facts	miwa	2008-03-06	2029-12-31	2008-03-06	110307. 01512.3-05.nut.pdf	2008-03-06	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 117	117	3	110307		01052, 01054, 01056	110307. RGT_M&S.nut.pdf	10 fl, 15 fl, 20 fl oz Roasted Garlic M&S Nutritio...	Roasted Garlic M&S nutrition nutritionals facts 01...	miwa	2008-03-06	2029-12-31	2008-03-06	110307. RGT_M&S.nut.pdf	2008-03-06	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 118	118	3	110307		01110	110307. TeriB&G.nut.pdf	12 12 wt oz Teriyaki B&G Nutrition Facts	Teriyaki Baste & Glaze nutrition nutritionals fact...	miwa	2008-03-06	2029-12-31	2008-03-06	110307. TeriB&G.nut.pdf	2008-03-06	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 119	119	3	110307		01185	110307. TeriB&GwithH&P.nut.pdf	12 12.8 wt oz Teriyaki B&G H&P Nutrition Facts	Teriyaki Baste & Glaze with Honey & Pineapple nutr...	miwa	2008-03-06	2029-12-31	2008-03-06	110307. TeriB&GwithH&P.nut.pdf	2008-03-06	1
Edit	Copy	Delete DELETE FROM `document_table` WHERE `document_table`.`doc_table_id` = 120	120	3	110307		01011, 01022, 01030, 01033, 01	110307. TeriM&S.nut.pdf	Teriyaki Nutrition Facts	Teriyaki nutrition nutritionals facts	miwa	2008-03-06	2029-12-31	2008-03-06	110307. TeriM&S.nut.pdf	2008-03-06	1

Check all With selected:

Filter rows:

Query results operations