Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: ksutds »Table: customer_bk
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 (6392 total, Query took 0.0009 seconds.)
SELECT * FROM `customer_bk`
[Edit inline] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh]
|
|
|
Number of rows:
Filter rows:
Sort by key:
Full textscustomer_codecustomer_typecustomer_namecustomer_addr1customer_addr2customer_citycustomer_statecustomer_zipcustomer_countrycustomer_phonecustomer_faxcustomer_emailcreate_usercreate_datemod_usermod_dateload_date
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011051\'
011051 40 INTERNATIONAL FLAVOR & FRAGRANCES 600 HIGHWAY 36 HAZLET NJ 07730 USA 0000000 JBAUER   1976-12-31 23:00:00 EMUTLU   2010-10-06 12:15:50 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011053\'
011053 10 INTERNATIONAL KITCHENS         107 WEBSTER AVE                                             HARRISON         NY 10528     USA 0000000                                         JBAUER   1976-09-30 23:00:00 AAUSER   0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011054\'
011054 30 INTERSTATE REST SUPPLY         DIV OF RYKOFF/SEXTON           P O BOX 11366/WASH STN         LOS ANGELES       CA 90011     USA 0000000                                         JBAUER   1975-04-30 23:00:00 JBAUER   0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011055\'
011055 30 INWOOD DAIRY                   527 WEST 44TH ST                                             NEW YORK         NY 10036     USA 0000000                                         JBAUER   1977-07-31 23:00:00 HETICAS 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011056\'
011056 50 ISLAND PARK DIST               1981 POND RD                                                 RONKONKOMA       NY 11779     USA 0000000                                         JBAUER   1975-07-31 23:00:00 AAUSER   0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011046\'
011046 30 INSTITUTIONAL PRODUCT         SERVICES/ACCTS PAYABLE         P O BOX 3055                   SAN FRANCISCO     CA 94080     USA 0000000                                         JBAUER   1975-04-30 23:00:00 AAUSER   0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011047\'
011047 30 INSTITUTIONAL WHSLE           P O BOX 4747                                                 MACON             GA 31208     USA 0000000                                         JBAUER   1983-01-31 23:00:00 AAUSER   0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011048\'
011048 71 INTERMODAL DELIVERY SERVICE P O BOX 982 SAN JOSE CA 95108 USA 0000000 JBAUER   1984-08-31 23:00:00 SCOTT   1999-08-16 15:34:04 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011049\'
011049 30 INTER-MART FOODS               1460 ATTEBURY LANE                                           SAN JOSE         CA 95133     USA 0000000                                         JBAUER   1986-07-31 23:00:00 AAUSER   0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011050\'
011050 10 INTERMIX DISTRIBUTOR           6841 EL PASO DR                                             EL PASO           TX 79926     USA 0000000                                         JBAUER   1986-11-30 23:00:00 AAUSER   0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011041\'
011041 30 INSTITUTION FOOD HOUSE, INC. P O DRAWER 2947 HICKORY NC 28603 USA 0000000 JBAUER   1980-08-31 23:00:00 KIIUSER 2009-02-02 12:40:55 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011042\'
011042 30 INSTITUTIONAL FOODS 2927 MAHONING AVE N W WARREN OH 44483 USA 0000000 JBAUER   1985-03-31 23:00:00 YOSH     2001-01-16 10:11:04 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011043\'
011043 30 INSTITUTIONAL JOBBERS P O BOX 51890 KNOXVILLE TN 37950-1890 USA 0000000 JBAUER   1982-08-31 23:00:00 KIIUSER 2009-02-02 12:40:55 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011044\'
011044 30 INSTITUTIONAL PRODUCT         SERVICES/ACCT PAYABLE         1351 LOWRIE AVE               SO SAN FRANCISCO CA 94080     USA 9810525                                         JBAUER   1975-04-30 23:00:00 AAUSER   0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011045\'
011045 30 INSTITUTIONAL PRODUCT         SERVICES/ACCT PAYABLE         1351 LOWRIE AVE               SO SAN FRANCISCO CA 94080     USA 0000000                                         JBAUER   1975-04-30 23:00:00 AAUSER   0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011036\'
011036 71 INDUSTRIAL FRT SYSTEMS P O BOX 99 SUN VALLEY CA 91353-099 USA 0000000 JBAUER   1986-06-30 23:00:00 SKONNO   1999-08-16 14:58:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011037\'
011037 71 INDUSTRIAL WAREHOUSE 2450 6TH AVE SOUTH SEATTLE WA 98134 USA 0000000 JBAUER   1976-09-30 23:00:00 SKONNO   1999-08-16 14:58:24 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011038\'
011038 40 INGREDIENT TECHNOLOGY CORP 1900 CHENAULT DR CARROLLTON TX 75006 USA 9724581030 9724581775 JBAUER   1987-03-31 23:00:00 SCOTT   1999-08-16 15:32:02 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011039\'
011039 30 GORDON FOOD SERVICE P O BOX 2825 GRAND RAPIDS MI 49501 USA 0000000 JBAUER   1979-02-28 23:00:00 SIDE     2010-08-27 14:57:59 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011040\'
011040 30 U.S. FOODSERVICE-JACKSON TRADE PAYABLES P O BOX 29283 PHOENIX AZ 85038-9283 USA 0000000 JBAUER   1978-10-31 23:00:00 RDOWNWAR 2010-07-28 14:39:34 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011031\'
011031 30 IMPORTED FOODS                 215 A ST                                                     BOSTON           MA 02210     USA 0000000                                         JBAUER   1985-01-31 23:00:00 AAUSER   0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011032\'
011032 30 INCHON INC                     7307 S HARL AVE STE 7                                       TEMPE             AZ 85283     USA 0000000                                         JBAUER   1986-09-30 23:00:00 AAUSER   0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'011033\'
011033 30 INDEPENDENT FOODS             P O BOX 428                                                 BURLINGTON       VT 05402     USA 0000000                                         JBAUER   1985-03-31 23:00:00 AAUSER   0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'010700\'
010700 10 FLEMING COMPANIES INC         CTP/HOUSTON DIVISION           P O BOX 24780                 OKLAHOMA CITY     OK 73124     USA 0000000                                         JBAUER   1975-04-30 23:00:00 HETICAS 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer_bk` WHERE `customer_bk`.`customer_code` = \'010701\'
010701 10 FLEMING FOODS COMPANY P O BOX 730 JOPLIN MO 64801 USA 0000000 JBAUER   1979-09-30 23:00:00 CCORNISH 2001-10-16 12:40:18 0000-00-00 00:00:00
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