Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: ksutds »Table: requests
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute query Press Enter to execute query
ascending
descending
Order:
Debug SQL
Count
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Collapse Expand Show trace Hide trace Count Time taken
Bookmarks
Refresh
Add
No bookmarks
Add bookmark
Options
Set default





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

Browse mode

Customize browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
Showing rows 0 - 24 (16590 total, Query took 0.0235 seconds.)
SELECT * FROM `requests`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
Number of rows:
Filter rows:
Sort by key:
Full textsreq_idreq_typecustomer_codecustomer_namecustomer_addr1customer_addr2customer_citycustomer_statecustomer_zipcustomer_countrycustomer_phonecustomer_faxattntitleemailemail_subjectdoc_typeuseruser_levelassiassi_emailksu_salesdue_dateduedatecreate_datecomp_dateappr_datesent_datestatusstscdebranchactive
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 1
1 A Real Foods 8030 S. 228th St Kent WA 98032 Kimberly Drown wng 2 2015-04-10 2015-04-10 10:33:48 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 OPN 1 HQ 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 2
2 A Engelhart Gourmet 2475 Courage Drive Fairfield CA 94533 Dominic Piccetti wng 2 2015-04-10 2015-04-10 10:54:06 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 OPN 1 HQ 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 3
3 A Orca Bay Seafoods 900 Powell Ave SW Renton WA 98057 425-687-4105 Roger Fickenscher rfickenscher@orcabayfoods.com wng 2 2015-04-10 2015-04-10 11:08:00 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 OPN 1 HQ 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 4
4 A 011265 NESTLE FOOD CO P O BOX 198 MORTON IL 61550-0198 USA 0000000 ssugano 2 2015-04-10 2015-04-10 11:21:10 0000-00-00 00:00:00 0000-00-00 00:00:00 2015-04-10 11:26:03 CMP 4 KMP 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 5
5 A 011265 NESTLE FOOD CO P O BOX 198 MORTON IL 61550-0198 USA 0000000 yhiraiwa 2 2015-04-10 2015-04-10 11:21:11 0000-00-00 00:00:00 0000-00-00 00:00:00 2015-04-10 11:26:03 CMP 4 HQ 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 6
6 A 011265 NESTLE FOOD CO P O BOX 198 MORTON IL 61550-0198 USA 0000000 ssugano 2 2015-04-10 2015-04-10 11:27:37 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 OPN 1 KMP 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 7
7 M 016457 SILVER SPRING 2424 ALPINE RD EAU CLAIRE WI 54703 USA Kai Hide R&D Manager yhiraiwa 2 04/20/2015 2015-04-20 2015-04-10 11:40:33 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 OPN 1 HQ 0
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 8
8 M 016457 SILVER SPRING 2424 ALPINE RD EAU CLAIRE WI 54703 USA Hide KAi R&D MGR. ssugano 2 04/20/2015 2015-04-20 2015-04-10 11:40:33 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 OPN 1 KMP 0
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 9
9 M 016457 SILVER SPRING 2424 ALPINE RD EAU CLAIRE WI 54703 USA Kai Hide R&D Manager yhiraiwa 2 04/20/2015 2015-04-20 2015-04-10 11:48:47 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 OPN 1 HQ 0
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 10
10 A 010359 CFS CONTINENTAL               P O BOX 84907                                               KENT             WA 98124-6207 USA 0000000           yhiraiwa 2 2015-04-10 2015-04-10 12:04:34 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 OPN 1 HQ 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 11
11 A 013956 NESTLE FOOD CO P O BOX 219 TRENTON MO 64683 USA 0000000 ssugano 2 2015-04-10 2015-04-10 12:04:56 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 OPN 1 KMP 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 12
12 A 011265 NESTLE FOOD CO P O BOX 198 MORTON IL 61550-0198 USA 0000000 ssugano 2 2015-04-10 2015-04-10 12:10:25 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 OPN 1 KMP 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 13
13 A 012864 AMERICAN AIRLINES             P O BOX 619047                 MAIL DROP 1104                 DRW AIRPORT       TX 75261-9047 USA 0000000           ssugano 2 2015-04-10 2015-04-10 12:16:40 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 OPN 1 KMP 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 14
14 A 016110 SOUTHEASTERN MILLS P O BOX 908 ROME GA 30165 USA cbarrientos@kikkoman.com, amigon@kikkoman.com htakemasa 2 2015-04-10 2015-04-10 15:00:14 0000-00-00 00:00:00 0000-00-00 00:00:00 2015-04-10 15:01:55 CMP 4 KMP 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 15
15 M 011145 KIKKOMAN FOODS INC N1365 SIX CORNERS RD P O BOX 69 WALWORTH WI 53184-0069 USA 0000000 Curtis anakamura 3 04/20/2015 2015-04-20 2015-04-10 16:02:31 2025-09-14 08:07:09 0000-00-00 00:00:00 2015-04-13 14:15:32 CMP 4 SF 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 16
16 A 017250 INDUSTRIAL COMMODITIES INC 1213 West N Carrier Pkwy #412 Grand Prairie TX 75050 USA 800-523-7902 Sabrina Trimiew STrimiew@industrialcommodities.com wng 2 2015-04-13 2015-04-13 10:28:08 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 CMP 1 HQ 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 17
17 A Pulmuone Foods 5775 Rossi Lane Gilroy CA 95020 Denise Vander Woude wng 2 2015-04-13 2015-04-13 11:37:30 0000-00-00 00:00:00 0000-00-00 00:00:00 2015-04-14 17:11:32 CMP 4 HQ 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 18
18 A Clark Associates, Inc. 40 Citation Lane Lititz PA 17543 Amy Mastrangelo wng 2 2015-04-13 2015-04-13 14:00:29 0000-00-00 00:00:00 0000-00-00 00:00:00 2015-04-14 16:58:33 CMP 4 HQ 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 19
19 A House of Thaller 1600 Harris Road Knoxville TN 37924 Carley Furguson wng 2 2015-04-13 2015-04-13 15:49:06 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 OPN 1 HQ 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 20
20 A 010756 4-W FOODS INC                 715 SO MISSION                                               SAPULPA           OK 74066     USA 0000000           thimeshi 2 2015-04-13 2015-04-13 20:19:42 0000-00-00 00:00:00 0000-00-00 00:00:00 2015-04-13 20:19:59 CMP 4 KMS 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 21
21 M 011145 KIKKOMAN FOODS INC N1365 SIX CORNERS RD P O BOX 69 WALWORTH WI 53184-0069 USA 0000000 Tak Miki QA Manager yhiraiwa 2 04/23/2015 2015-04-23 2015-04-13 20:26:06 0000-00-00 00:00:00 0000-00-00 00:00:00 2015-04-13 20:35:25 CMP 4 HQ 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 22
22 M 014891 TREE OF LIFE MW-BLOOMINGTON  IN P O BOX 389 ACCT. PAYABLE ST. AUGUSTINE FL 320850389 USA 812-335-6212 812-335-6213 yhiraiwa 2 04/23/2015 2015-04-23 2015-04-13 22:30:13 0000-00-00 00:00:00 0000-00-00 00:00:00 2015-04-16 08:17:57 CMP 4 HQ 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 23
23 A The French’s Food Company 4 Mill Ridge Lane Chester NJ 07930 Zara Nassiry Regulatory Associate wng 2 2015-04-14 2015-04-14 11:02:34 0000-00-00 00:00:00 0000-00-00 00:00:00 2015-04-14 16:56:58 CMP 4 HQ 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 24
24 M The French’s Food Company 4 Mill Ridge Lane Chester NJ 07930 Zara Nassiry Regulatory Associate wng 2 Carol Barrientos cbarrientos@kikkoman.com 04/24/2015 2015-04-24 2015-04-14 11:48:50 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 CMP 4 HQ 1
Edit EditCopy CopyDelete Delete
DELETE FROM `requests` WHERE `requests`.`req_id` = 25
25 A The French’s Food Company 4 Mill Ridge Lane Chester NJ 07930 Zara Nassiry Regulatory Associate wng 2 2015-04-14 2015-04-14 11:55:16 0000-00-00 00:00:00 0000-00-00 00:00:00 0000-00-00 00:00:00 OPN 1 HQ 1
With selected: With selected:

|
|
|
Number of rows:
Filter rows:
Sort by key:
Query results operationsPrint PrintCopy to clipboard Copy to clipboardExport Export Display chart Display chart Create view Create view

Bookmark this SQL query Bookmark this SQL query