Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: ksutds »Table: customer
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 (9174 total, Query took 0.0012 seconds.)
SELECT * FROM `customer`
[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` WHERE `customer`.`customer_code` = \'011158\'
011158 10 KINSTON WHSLE GROC CO P O BOX 1375 KINSTON NC 28501 USA NULL JBAUER 0000-00-00 00:00:00 KIIUSER 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'010095\'
010095 40 ANDRIA'S 6813 OLD COLLINSVILLE RD O'FALLON IL 62269 USA INFO@ANDRIAS.COM;AFG.PRODUCTION@ANDRIAS.COM;accoun JBAUER 1984-12-01 00:00:00 TLEE 2026-06-25 11:31:12 2026-06-29 03:12:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'010096\'
010096 30 ANDREWS FOOD SERVICE 717 E INDUSTRIAL BLVD PUEBLO WEST CO 81007 USA NULL JBAUER 1980-09-01 00:00:00 CYAM 2026-01-07 10:17:29 2026-01-09 02:11:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'013111\'
013111 30 ALABAMA INSTITUTIONAL FOODS PO BOX 1420 TUSCALOOSA AL 35401 USA NULL JBAUER 0000-00-00 00:00:00 KIIUSER 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'013756\'
013756 10 C.G.F. CASH & CARRY 455 TOLAND SAN FRANCISCO CA 94124 USA NULL JBAUER 0000-00-00 00:00:00 AAUSER 2017-05-08 22:08:28 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'011163\'
011163 40 UNIVERSAL FLAVORS-U.S.A.,CORP P O BOX 13 HARRISON NJ 07029 USA NULL JBAUER 0000-00-00 00:00:00 AAUSER 2017-05-08 22:03:36 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'012474\'
012474 20 DECA EAST SERVICE CENTER COMMERCIAL ACCOUNTS P O BOX 90028 FORT LEE VA 23801-390 USA NULL JBAUER 0000-00-00 00:00:00 MJANANPO 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'019715\'
019715 30 NORTHWESTERN K & L MEATS 3131 MACK AVE DETROIT MI 48207 USA NULL RDOWNWAR 0000-00-00 00:00:00 CYAM 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'012475\'
012475 20 DECA EAST SERVICE CENTER COMMERCIAL ACCOUNTS P O BOX 90028 FORT LEE VA 23801-390 USA NULL JBAUER 0000-00-00 00:00:00 MJANANPO 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'010090\'
010090 40 AMSNACK INC P O BOX 148 FRENCH CAMP CA 95231 USA NULL JBAUER 0000-00-00 00:00:00 LINDA 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'010091\'
010091 30 ANCO FOODSERVICE P O BOX 24627 SEATTLE WA 98124 USA NULL JBAUER 0000-00-00 00:00:00 RDOWNWAR 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'013573\'
013573 10 FOOD PRODUCTS COMPANY P. O. BOX 5281 DENVER CO 80217-5281 USA NULL JBAUER 0000-00-00 00:00:00 HETICAS 2017-05-08 22:07:31 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'010094\'
010094 71 F R ANDERSON INC P O BOX 782 DES MOINES IA 50306 USA NULL JBAUER 0000-00-00 00:00:00 SCOTT 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'012135\'
012135 71 T & K EXPRESSWAYS P O BOX 2058 VACAVILLE CA 95696 USA NULL JBAUER 0000-00-00 00:00:00 SKONNO 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'012471\'
012471 20 DECA EAST SERVICE CENTER COMMERCIAL ACCOUNTS P O BOX 90028 FORT LEE VA 23801-390 USA NULL JBAUER 0000-00-00 00:00:00 CCORNISH 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'012472\'
012472 20 DECA EAST SERVICE CENTER COMMERCIAL ACCOUNTS P O BOX 90028 FORT LEE VA 23801-6390 USA NULL JBAUER 0000-00-00 00:00:00 DALLISON 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'012473\'
012473 20 DECA EAST SERVICE CENTER COMMERCIAL ACCOUNTS P O BOX 90028 FORT LEE VA 23801-6390 USA NULL JBAUER 0000-00-00 00:00:00 MJANANPO 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'018400\'
018400 30 ROMA FOODS OR FLORIDA 2901 TITAN ROW SUITE 136 ORLANDO FL 32809 USA NULL RDOWNWAR 2012-07-30 15:00:01 CYAM 2026-01-06 09:08:04 2026-01-09 02:11:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'012465\'
012465 20 DECA EAST SERVICE CENTER COMMERCIAL ACCOUNTS P O BOX 90028 FORT LEE VA 23801-6390 USA NULL JBAUER 0000-00-00 00:00:00 MJANANPO 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'010040\'
010040 10 AKEL WHOLESALE GROCERY P O BOX 490 JOHNSON CITY NY 13790 USA NULL JBAUER 0000-00-00 00:00:00 MYAMADA 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'011410\'
011410 10 MCLANE/WESTERN, INC. CENTRAL TRADE PAYABLES P O BOX 6131 TEMPLE TX 76503-6131 USA NULL JBAUER 0000-00-00 00:00:00 MYAMADA 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'019565\'
019565 30 HOME FOLKS 2001 W SIDE DR AUGUSTA GA 30907 USA NULL RDOWNWAR 2014-09-03 13:33:00 CYAM 2026-01-07 13:54:20 2026-01-09 02:11:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'017842\'
017842 40 AUGUST FOODS, INC. 444 ACORN LANE DOWNINGTOWN PA 19335 USA 610-873-3663 610-873-3660 HSANDHU@AUGUSTFOODS.COM CCORNISH 0000-00-00 00:00:00 NULL 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'014787\'
014787 10 L & L/JIROCH DISTRIBUTING CO 1180 58TH STREET SW WYOMING MI 49509 USA NULL DLSAPPIN 0000-00-00 00:00:00 YOSH 0000-00-00 00:00:00 0000-00-00 00:00:00
Edit EditCopy CopyDelete Delete
DELETE FROM `customer` WHERE `customer`.`customer_code` = \'012090\'
012090 10 UNFI CONVENTIONAL CENTRAL DISBURSEMENT PO BOX 11820 COLLEGE STATION TX 77842 USA 979-217-3466 NULL JBAUER 1978-02-01 00:00:00 NFESPERM 2026-06-24 08:28:34 2026-06-26 03:11:57
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