www.kikkoman.mx / 127.0.0.1 / ksuiso / pso_req

Recent`ksutds`.`requests`
`kikko`.`ghk_removal`
`ksussg`.`sp_analysis`
`kikko`.`activity_v2`
`kikko`.`new_products`
`kikko`.`level_1`
`information_schema`.`KEY_COLUMN_USAGE`
`kikko`.`user_bk`
`ksussg`.`spec_user`
`kikko`.`page_description`
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: ksuiso »

Table: pso_req

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 (3681 total, Query took 0.0010 seconds.)

SELECT * FROM `pso_req`

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

Filter rows:

			req_id	job_id	customer_code	customer_name	customer_addr1	customer_addr2	customer_city	customer_state	customer_zip	customer_country	customer_phone	attn	email	broker	spec_sht	tracking_no	purpose	rd_desc	other_desc	shipvia	shipdate	due_date	user	user_level	branch	approvedate	create_date	comp_date	status 1=OPN, 2=SHP	active
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 1	1	160919001	019301	7 STAR FOODS	530 N PUENTE ST		BREA	CA	92821	USA					Y	123456789	DONATION,OFFICE USE			NEXT DAY AM	2016-09-27 10:34:54	2016-09-28	curtis	3	SF	NULL	2016-09-19 12:54:21	NULL	COMP	0
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 2	2	160919002	NEW	Tokyo Design Center	1508 Fillmore St Suite 300		San Francisco	CA	94115	USA	415-543-4886	Curtis Tsukano	curtis@tokyodesign.com			123789	TEST KITCHEN,DONATION,SALES USE		Free Sample	NEXT DAY AM	2017-01-19 15:12:27	2016-09-22	curtis	3	HQ	NULL	2016-09-19 13:00:49	NULL	2	0
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 3	3	160919003	019966	A & C DISTRIBUTORS	4048 W CHICAGO AVE		CHICAGO	IL	60639	USA					Y		TRADE SHOW			NEXT DAY AM	NULL	2016-09-20	curtis	3	SF	NULL	2016-09-19 13:20:57	NULL	OPEN	0
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 7	7	160923004	015136	FIRST SPICE MIXING CO INC	33-33 GREENPOINT AVE		LONG ISLAND	NY	11101	USA	2211105	Marcy Epstein			Y			dry seasoning blend		2ND DAY	2016-09-23 16:38:28	2016-09-27	curtis	3	SF	NULL	2016-09-23 11:30:20	NULL	COMP	0
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 8	8	160926001	014309	ADVANCE FOOD SYSTEM	21 ROOSEVELT AVENUE		SOMERSET	NJ	08873	USA					Y					NEXT DAY EXPRESS	2017-01-25 23:58:10	0000-00-00	curtis	3	HQ	NULL	2016-09-26 15:35:01	NULL	2	0
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 9	9	160926002	014309	ADVANCE FOOD SYSTEM	21 ROOSEVELT AVENUE		SOMERSET	NJ	08873	USA					Y					NEXT DAY EXPRESS	NULL	0000-00-00	curtis	3	NY	NULL	2016-09-26 15:35:07	NULL	OPEN	0
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 10	10	160927001	017168	A & L SALES, INC.	P.O. BOX 74		BELLE CHASSE	LA	70037	USA	3943840				Y					NEXT DAY AM	NULL	2016-09-14	curtis	3	HQ	NULL	2016-09-27 10:32:01	NULL	OPEN	0
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 11	11	160927002	017168	A & L SALES, INC.	P.O. BOX 74		BELLE CHASSE	LA	70037	USA	3943840				Y	123456789				NEXT DAY AM	2016-12-06 11:58:13	2016-09-14	curtis	3	NY	NULL	2016-09-27 10:32:08	NULL	2	0
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 12	12	161116001	014468	NESTLE REFRIGERATED FOODS	1534 EL PINAL		STOCKTON	CA	95205	USA					Y	123456, 456789,8888				NEXT DAY AM	2017-01-24 17:18:53	2016-11-17	curtis	0	SF	NULL	2016-11-16 10:22:27	2017-01-27 15:04:39	3	1
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 13	13	161116002	015027	KAGOME FOODS INC	R & D FACILITY/ATN:GWEN YOUNG		BELMONT	CA	94002	USA	3492271				Y	0000000000000				NEXT DAY AM	2017-01-27 13:50:07	2016-11-17	aisobe	0	SF	NULL	2016-11-16 10:32:09	NULL	2	1
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 14	14	161216002	018486	TAYLOR FARMS NORTHWEST, LLC.	8030 S. 228TH STREET		KENT	WA	98032	USA	6251412		AP-DIRECT@TAYLORFARMS.COM	NORTHWEST INGREDIENTS - SEATTLE	Y	iz00000				2ND DAY	2016-12-16 09:47:42	2016-12-20	aisobe	0	SF	NULL	2016-12-16 09:44:42	NULL	2	1
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 15	15	170106001	011265	NESTLE FOOD CO	P O BOX 198		MORTON	IL	61550-0198	USA						88888888888				2ND DAY	2017-01-06 11:11:59	0000-00-00	aisobe	0	HQ	NULL	2017-01-06 11:09:28	NULL	2	1
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 16	16	170110001		Kikkoman Marketing & Planning, Inc.	2500 West Higgins Road, Wuite 1180		Hoffman Estates	IL	60169	USA	847-882-8901	Shuji Sugano	ssugano@kikkoman.com			1Z9510011257464844				GROUND TRACK (7 DAYS)	NULL	2017-01-17	aisobe	0	HQ	NULL	2017-01-10 15:16:47	2017-01-12 16:16:14	3	1
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 17	17	170110003		Kikkoman Marketing & Planning, Inc.	2500 West Higgins Road, Wuite 1180		Hoffman Estates	IL	60169	USA	847-882-8901	Shuji Sugano				1z9510011257944763				3RD DAY	2017-01-11 16:30:50	2017-01-16	aisobe	0	HQ	NULL	2017-01-10 19:06:50	NULL	2	1
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 18	18	170112001		KMP c/o Siliver Spring Foods	2424 Alpine Rd		Eau Claire	WI	54703	USA	224-238-0855	Hidehito Kai				1Z9510010358059459				GROUND TRACK (7 DAYS)	NULL	2017-01-20		0		NULL	2017-01-12 11:09:51	2017-01-12 16:21:19	3	0
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 19	19	170113001		Kikkoman Marketing & Planning	2500 West Higgins Road, Suite 1180		Hoffman Estate	IL	60169	USA	847-882-2901	Shuji Sugano			Y	1Z9510010357227993/ 1Z9510010357232469				GROUND TRACK (7 DAYS)	NULL	2017-01-20	aisobe	0	HQ	NULL	2017-01-13 15:29:45	2017-01-31 11:27:29	3	1
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 20	20	170119001	016618	KIKKOMAN MARKETING & PLANNING INC	2500 West Higgins Rd. Suite1180		Hoffman Estates	IL	60169	USA		Shuji Sugano			Y					GROUND TRACK (7 DAYS)	2017-01-20 09:17:06	2017-01-26	aisobe	3	HQ	NULL	2017-01-19 15:43:16	2017-01-26 16:16:44	3	1
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 21	21	170120001		ComeIn de México	Federalismo #122	Fracc. Industrial la Silla.	Guadalupe	N.L.	CP. 61799	Mexico	52(81)8361 7440	Carolina Herrera	carolina.herrera@comein.com.mx		Y	1Z9510010457991094		MSG replacer, injection and tumber		INTL SAVER	2017-01-23 16:28:50	0000-00-00	aisobe	0	HQ	NULL	2017-01-20 15:03:30	2017-01-23 16:29:42	3	1
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 22	22	170131002		ComeIn de Mexico c/o MS Worldwide Logistics Inc.	822 Union Pacific Blvd.	East Point Industrial Park	Laredo	TX	78045	USA	(956) 791-5402	Carolina Herrera				1z9510010258526106				2ND DAY	NULL	2017-02-02	aisobe	0	HQ	NULL	2017-01-31 15:37:46	2017-02-02 17:15:39	3	1
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 23	23	170206001		KMP c/o Siliver Spring Foods	2424 Alpine Rd		Eau Claire	WI	54703	USA	224-238-0855	Hidehito Kai				3RD DAY SERVICE, Tracking # 1Z9510011256951355				GROUND TRACK (7 DAYS)	NULL	2017-02-10	aisobe	0	HQ	NULL	2017-02-06 14:39:39	2017-02-06 15:57:36	3	1
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 24	24	170214001		test	test					USA						2222222				NEXT DAY PM	2017-02-16 19:40:48	2017-02-15	admin	0	HQ	NULL	2017-02-14 17:14:28	NULL	2	0
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 25	25	170214002		Kikkoman Marketing & Planning	2500 West Higgins Road, Suite 1180		Hoffman Estate	IL	60169	USA	847-882-2901		undefined	undefined		UPS 3rd day service, Tracking# 1Z9510011258932783				GROUND TRACK (7 DAYS)	2017-02-16 16:33:30	2017-02-21	aisobe	0	HQ	NULL	2017-02-14 17:21:51	NULL	2	1
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 26	26	170221001		Kewpie Corporation	Dept of Overseas, Institute of Product Development...	Sengawa Kewport, 2-5-7, Sengawa-cho	Chofu-shi	Tokyo	182-0002	Japan	=81-3-5384-7762	Mr. Mimura Akihiro				1Z9510010457785745				INTL SAVER	2017-02-21 16:39:35	2017-02-28	aisobe	0	HQ	NULL	2017-02-21 15:52:00	NULL	2	1
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 27	27	170227002		KMP c/o Siliver Spring Foods	2424 Alpine Rd		Eau Claire	WI	54703	USA	224-238-0855	Hidehito Kai	undefined	undefined						GROUND TRACK (7 DAYS)	2017-02-28 09:30:14	2017-03-06	aisobe	0	HQ	NULL	2017-02-27 14:16:20	NULL	2	1
Edit	Copy	Delete DELETE FROM `pso_req` WHERE `pso_req`.`req_id` = 28	28	170227004		test						USA		test									2017-02-27 18:51:06	0000-00-00	HQ	0	Head Quarter	NULL	2017-02-27 18:50:08	2017-02-27 18:52:01	3	0

Check all With selected:

Filter rows:

Query results operations