Drop files here

SQL upload ( 0 ) x -

Page-related settings Click 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.
Browse mode
Documentation Use only icons, only text or both. Restore default value
Documentation Use only icons, only text or both. Restore default value
Documentation Whether a user should be displayed a "show all (rows)" button. Restore default value
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown. Restore default value
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise. Restore default value
Documentation Highlight row pointed by the mouse cursor. Restore default value
Documentation Highlight selected rows. Restore default value
Documentation Restore default value
Documentation Restore default value
Documentation Repeat the headers every X cells, 0 deactivates this feature. Restore default value
Documentation Maximum number of characters shown in any non-numeric column on browse view. Restore default value
Documentation These are Edit, Copy and Delete links. Restore default value
Documentation Whether to show row links even in the absence of a unique key. Restore default value
Documentation Default sort order for tables with a primary key. Restore default value
Documentation When browsing tables, the sorting of each table is remembered. Restore default value
Documentation For display Options Restore default value
SELECT * FROM `datasuplier` ORDER BY `kota` DESC 
Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
Full texts kode_suplier nama_suplier alamat kota Descending Ascending 1 no_telp nama_bank rekening
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF01'
PBF01 PT. ANDESLA ANANDA THARRA JL. UNGGAS ANGSA PUTIH NO. 03 PEKANBARU 07616701587 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF27'
PBF27 PT. SAPTA SARI TAMA JL. SELAIS NO.09 PEKANBARU 0 BCA 0341199505
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF32'
PBF32 PT. UNITED DICO CITAS JL. TANJUNG DATUK NO 116 PEKANBARU 0761839125 BCA 00216002862
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF33'
PBF33 PT. KAFFA MEDIKA RIAU JL. BELANAK, TANGKERANG BARAT, MARPOYAN DAMAI, PKU PEKANBARU 0761839125 MANDIRI 1080035222224
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF04'
PBF04 PT. ANUGRAH ARGON MEDICA JL. SM. AMIN NO. 169 A-F RT 01/RW 17, KEL. SIMPANG PEKANBARU 07616700121 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF07'
PBF07 PT. ENSEVAL PUTERA MEGATRADING, TBK JL. BUKIT BARISAN I, RT 01/RW 07 NO. 03, KEL. TANG PEKANBARU 07616704288 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'KL01'
KL01 KLINIK PRATAMA UES MEDIKA JL. RAWA INDAH, SIDOMULYO, MARPOYAN DAMAI, PEKAN PEKANBARU 0 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF34'
PBF34 PT. GREAT DELI FARMA JLN TUANKU TAMBUSAI, KOMP. NANGKA RAYA PERMAI PEKANBARU 0761572044 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'APT18'
APT18 APOTEK ASEAN PEKANBARU PEKANBARU PEKANBARU 0 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF17'
PBF17 PT. MENSA BINASUKSES PEKANBARU PEKANBARU 0 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF20'
PBF20 PT. NARECO LESTARI JLN. LEGA SARI NO, 104 RT/RWM003/003 PEKANBARU PEKANBARU 007618403048 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF28'
PBF28 PT. SINAR MEDIKA ALKESINDO JL.Jati No. 62, Pekanbaru PEKANBARU 0 BCA 8230405361
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF02'
PBF02 PT. ANTARMITRA SEMBADA JL. AIR HITAM BLOK B 1-4 KOMP PERGUDANGAN GOLDEN C PEKANBARU 07616706800 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'ALK02'
ALK02 ALKES JANTRA JL. AHMAD YANI NO. 129 PKU PEKANBARU 0 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF08'
PBF08 PT. KEBAYORAN PHARMA JL. KENANGA NO. 46, KEL. PADANG TERUBUK, KEC. SENA PEKANBARU 0761885472 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF12'
PBF12 PT. MILLENNIUM PHARMACON INTERNATIONAL JL. PINANG NO. 89, KEL. WONOREJO, KEC. MARPOYAN DA PEKANBARU 07617874997 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF14'
PBF14 PT. PENTAVALENT JL. TEUKU ZAINAL ABIDIN NO. 5 PEKANBARU 076121934 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF29'
PBF29 PT. DAYA MUDA AGUNG JL.Tuanku Tambusai, Komp Taman Mella Blok H, Pku PEKANBARU 0 BCA 2207774452
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF03'
PBF03 PT. ANUGERAH PHARMINDO LESTARI JL. SIAK 2 KM. 15 NO. 7/8, RUMBAI PEKANBARU 076142717 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF09'
PBF09 PT. KIMIA FARMA JL. SISINGAMANGARAJA NO. 18A PEKANBARU 076132712 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF15'
PBF15 PT. TRI SAPTA JAYA KOMPLEK TAMAN MELLA, JL. TUANKU TAMBUSAI NO.5-6 PEKAN BARU 06276131880 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF26'
PBF26 PT. AKIRA ANUGRAH MEDIKA JL. JATI 3 NO 112 MEDAN MEDAN 082210999663 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF18'
PBF18 PT. ADYA ARTHA ABADI JL. SISINGMARAJA KM. 10.8 PERGUDANGAN MEDAN 0 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF16'
PBF16 PT. DANVI MEDILAB PERKASA MEDAN MEDAN 0 - -
Edit Edit Copy Copy Delete Delete
DELETE FROM datasuplier WHERE `datasuplier`.`kode_suplier` = 'PBF22'
PBF22 PT. ENDO MEDICA NUSANTARA JL. TEGAKAB BI. 1G MATRAMAN JAKARTA TIMUR 0 - -
With selected: With selected:
Query results operations Copy to clipboard Copy to clipboard Export Export Display chart Display chart Create view Create view
Bookmark this SQL query Bookmark this SQL query