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 :
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 `psi_data_tables`
[ Edit inline ] [ Edit ] [ Explain SQL ] [ Create PHP code ] [ Refresh ]
|
|
|
|
Filter rows:
Sort by key:
Full texts id_data apps_id data_title data_description dependency_id id_query search_col sort_col show_col show_caption new_col_caption new_trigger_query id_form_new edit_col_caption edit_trigger_query id_form_edit view_col_caption id_form_view v_additional_button_1 v_button_1_condition v_additional_button_2 v_button_2_condition v_additional_button_3 v_button_3_condition insert_date insert_by update_date update_by delete_date delete_by is_deleted new_form_title edit_form_title view_form_title two_column_flag
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 1
 		1 1 data table 1 data table 1 desc NULL 4 id|id,nama_produk|nama_produk,merek|merek,type|typ... id,nama_produk,merek,type, id,nama_produk,merek,type, id,nama_produk,merek,type, NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2022-09-02 14:36:33 system 2022-10-24 00:17:12 admin NULL 0 NULL NULL NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 2
 		2 1 data table 2 data table 2 desc NULL 4 NULL NULL NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL 2022-09-02 14:36:33 system 2022-10-24 00:02:18 admin NULL NULL 0 NULL NULL NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 3
 		3 0 TABEL DAFTAR STOCK BARANG NULL NULL 3 Nama Produk|nama_produk,Merek|merek,Type|type, id,merek,type, id,nama_produk,merek,type, id,Nama Produk,Merek,Type, [
   {
       "two_column_flag": "1",
      ...		 NULL NULL [
   {
       "two_column_flag": "1",
      ...		 NULL NULL [
   {
       "two_column_flag": "1",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-09-06 00:04:02 1 2022-09-20 21:15:50 admin NULL NULL 0 Input Data Barang Edit Data Karyawan View Data Karyawan 1
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 4
 		4 23 TABLE MASTER CITY NULL NULL 10 code|code,name|name,description|description, code,name,description, code,name,description, code,name,description, [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-10-24 01:10:54 admin 2022-10-24 21:20:29 admin NULL NULL 0 Input Data City Edit Data City View Data City 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 5
 		5 26 DATA MASTER PROJECT NULL NULL 13 Project Code|project_code,Project Name|project_nam... project_code,project_name,description,id_group, project_code,project_name,description,id_group, Project Code,Project Name,Description,Group Name, [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-10-25 03:58:26 admin 2022-09-23 05:24:06 admin 2022-11-01 06:15:55 admin 1 Input Master Project Edit Master Project View Master Project 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 6
 		6 26 TABEL PROJECT NEW NULL NULL 14 project_code|project_code,project_name|project_nam... project_code,project_name,description,group_name, project_code,project_name,description,group_name, project_code,project_name,description,group_name, [
   {
       "two_column_flag": "0",
      ...		 NULL 10 [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-10-24 18:02:57 admin 2022-09-24 18:24:50 admin 2022-11-01 06:15:58 admin 1 Input Data Project NULL NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 7
 		7 26 TABLE PROJECT GROUP NULL NULL 14 project_code|project_code,project_name|project_nam... project_code,project_name,description,grp.group_co... project_code,project_name,description,group_code,g... project_code,project_name,description,grp.group_co... [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-10-27 21:49:23 admin 2022-09-27 02:36:49 admin 2022-11-01 06:16:04 admin 1 Input Data Project Edit Data Project View Data Project 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 8
 		8 26 DATA PENDUDUK 2022 NULL NULL 23 NIK|nik,Nama Lengkap|name,Alamat|address,Provinsi|... nik,name,address,prov_name,kab_name,kec_name,desa_... nik,name,address,prov_name,kab_name,kec_name,desa_... NIK,Nama Lengkap,Alamat,Provinsi,Kabupaten,Kecamat... [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-09-28 02:02:12 admin 2022-09-28 04:52:33 admin 2022-11-01 06:16:08 admin 1 NULL NULL NULL 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 9
 		9 26 DATA PENDUDUK REPUBLIK KONOHA NULL NULL 24 nik|nik,Nama Lengkap|full_name,Alamat|address,Prop... nik,full_name,address,prov_name,kabupaten_name,kec... nik,full_name,address,prov_name,kabupaten_name,kec... nik,Nama Lengkap,Alamat,Propinsi,Kabupaten,Kecamat... [
   {
       "two_column_flag": "1",
      ...		 NULL NULL [
   {
       "two_column_flag": "1",
      ...		 NULL NULL [
   {
       "two_column_flag": "1",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-10-30 23:00:18 admin 2022-09-28 20:27:09 admin NULL NULL 0 Tambah Penduduk Ubah Data Penduduk Lihat Data Penduduk 1
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 10
 		10 26 DAFTAR PROJECT NULL NULL 25 Kode Proyek|project_code,Nama Proyek|project_name,... project_code,project_name,description,group_name, project_code,project_name,description,group_name, Kode Proyek,Nama Proyek,Keterangan,Group, [
   {
       "two_column_flag": "1",
      ...		 NULL NULL [
   {
       "two_column_flag": "1",
      ...		 NULL NULL [
   {
       "two_column_flag": "1",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-10-31 20:26:20 admin 2022-11-02 20:08:29 admin NULL NULL 0 TAMBAH DATA PROYEK UBAH DATA PROYEK LIHAT DATA PROYEK 1
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 11
 		11 26 DAFTAR PROJECT GROUP NULL NULL 26 KODE GROUP|group_code,NAMA GROUP|group_name,KETERA... group_code,group_name,group_description, group_code,group_name,group_description, KODE GROUP,NAMA GROUP,KETERANGAN, [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-10-31 21:27:23 admin 2022-11-24 21:08:47 ken.nurdiattama NULL NULL 0 TAMBAH DATA GROUP PROYEK UBAH DATA GROUP PROYEK LIHAT DATA GROUP PROYEK 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 12
 		12 26 DAFTAR DIVISI NULL NULL 28 KODE DIVISI|division_code,NAMA DIVISI|division_nam... division_code,division_name,description, division_code,division_name,description, KODE DIVISI,NAMA DIVISI,KETERANGAN, [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-11-01 02:30:31 admin 2022-11-01 02:30:31 admin NULL NULL 0 TAMBAH DATA DIVISI UBAH DATA DIVISI LIHAT DATA DIVISI 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 13
 		13 26 DAFTAR VENDOR NULL NULL 29 Vendor Code|vendor_code,Vendor Name|vendor_name,Ve... vendor_code,vendor_name,jenis_usaha,vendor_status,... vendor_code,vendor_name,jenis_usaha,vendor_status,... Vendor Code,Vendor Name,Vendor Type,Status,Service... [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-11-01 02:35:56 admin 2022-11-07 22:51:46 nurdiana.handayani NULL NULL 0 TAMBAH DATA VENDOR UBAH DATA VENDOR LIHAT DATA VENDOR 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 14
 		14 26 DT_MASTER_CUSTOMERS_CUSTOM_FORM NULL NULL 127 Code|code,Customer Name|name,Business Permit|busin... code,name,business_permit,customer_type,city,coa,s... code,name,business_permit,customer_type,city,coa,s... Code,Customer Name,Business Permit,Customer Type,C... [
   {
       "two_column_flag": "1",
      ...		 NULL 26 [
   {
       "two_column_flag": "1",
      ...		 NULL 26 [
   {
       "two_column_flag": "1",
      ...		 26 NULL NULL NULL NULL NULL NULL 2022-11-01 03:22:29 admin 2022-12-03 19:52:44 ken.nurdiattama NULL NULL 0 Add New Customer Edit Customer List View Customer List 1
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 15
 		15 0 DATA CUSTOMER NULL NULL 31 Customer Code|code,Customer Name|name,Address|addr... code,name,address, code,name,address, Customer Code,Customer Name,Address, [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-09-30 21:05:50 admin 2022-10-01 03:50:16 admin NULL NULL 0 Input Data Customer Edit Data Customer VIEW DATA CUSTOMER 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 16
 		16 23 DATA PENDUDUK RAJEG NULL NULL 33 Customer Code|customer_code,Customer Name|customer... customer_code,customer_name,address, customer_code,customer_name,address, Customer Code,Customer Name,Address, [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-10-01 22:59:50 admin 2022-10-01 22:59:50 admin NULL NULL 0 Input Data Customer Edit Data Customer View Data Customer 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 17
 		17 26 DAFTAR PRODUK NULL NULL 35 KODE PRODUK,product_code,NAMA PRODUK|product_name,... product_code,product_name,description,pgroup_name, product_code,product_name,description,pgroup_name, KODE PRODUK,NAMA PRODUK,KETERANGAN,GRUP PRODUK [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-11-02 19:18:20 admin 2022-11-02 19:27:20 admin NULL NULL 0 TAMBAH  DATA PRODUK UBAH DATA PRODUK LIHAT DATA PRODUK 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 18
 		18 26 DAFTAR PRODUCT GROUP NULL NULL 36 PRODUCT GROUP CODE|pgroup_code,PRODUCT GROUP NAME|... pgroup_code,pgroup_name,description, pgroup_code,pgroup_name,description, PRODUCT GROUP CODE,PRODUCT GROUP NAME,DESCRIPTION, [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-11-02 19:22:51 admin 2022-11-02 19:22:51 admin NULL NULL 0 TAMBAH GRUP PRODUK UBAH GRUP PRODUK LIHAT GRUP PRODUK 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 19
 		19 26 DAFTAR SERVIS GRUP NULL NULL 38 KODE GRUP|sgroup_code,NAMA GRUP|sgroup_name,KETERA... sgroup_code,sgroup_name,description, sgroup_code,sgroup_name,description, KODE GRUP,NAMA GRUP,KETERANGAN, [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-11-02 19:40:29 admin 2022-11-02 19:40:29 admin NULL NULL 0 TAMBAH GRUP SERVIS UBAH GRUP SERVIS LIHAT GRUP SERVIS 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 20
 		20 26 DAFTAR SERVIS NULL NULL 37 KODE SERVIS|service_code,NAMA SERVIS|service_name,... service_code,service_name,description,sgroup_name, service_code,service_name,description,sgroup_name, KODE SERVIS,NAMA SERVIS,KETERANGAN,GRUP SERVIS, [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-11-02 19:44:11 admin 2022-11-04 01:49:20 admin NULL NULL 0 TAMBAH DATA SERVIS UBAH DATA SERVIS LIHAT DATA SERVIS 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 21
 		21 26 DAFTAR SI BUSINESS UNIT NULL NULL 39 COMPANY CODE|company_code,COMPANY NAME|company_nam... company_code,company_name, company_code,company_name, COMPANY CODE,COMPANY NAME, [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-11-02 20:58:29 admin 2022-11-02 20:58:29 admin NULL NULL 0 TAMBAH DATA SI BUSINESS UNIT UBAH DATA SI BUSINESS UNIT LIHAT DATA SI BUSINESS UNIT 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 22
 		22 26 DAFTAR QUOTATION NULL NULL 40 NO QUOTATION|quotation_no,TANGGAL|tanggal,KETERANG... quotation_no,tanggal,keterangan, quotation_no,tanggal,keterangan, NO QUOTATION,TANGGAL,KETERANGAN, [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-11-04 00:42:37 admin 2022-11-04 03:08:27 ken.nurdiattama NULL NULL 0 TAMBAH DATA QUOTATION UBAH DATA QUOTATION LIHAT  DATA QUOTATION 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 23
 		23 27 COST CENTER cost center NULL 42 cost center  code |COSTCENTER_CODE,cost center nam... COSTCENTER_CODE,COSTCENTER_NAME_ID COSTCENTER_CODE,COSTCENTER_NAME_ID,ADDRESS,TELP, cost center  code,cost center name,Address,Telp, [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-11-03 20:26:59 kahfi.resmana 2022-11-03 20:26:59 kahfi.resmana NULL NULL 0 Input Data Cost Center Input Data Cost Center Input Data Cost Center 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 24
 		24 27 POSITION POSITION NULL 44 position_code|position_code,Position_name|Position... position_id,position_code,Position_name,cost_Cente... position_id,position_code,Position_name,cost_Cente... position_id,position_code,Position_name,cost_Cente... [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL [
   {
       "two_column_flag": "0",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-11-03 20:48:34 kahfi.resmana 2022-11-03 20:48:34 kahfi.resmana NULL NULL 0 Input Position Input Position Input Position 0
Edit Edit Copy Copy Delete Delete
DELETE FROM psi_data_tables WHERE `psi_data_tables`.`id_data` = 25
 		25 27 EMPLOYEE employee information NULL 43 EMP_ID|EMP_ID,FIRST_NAME|FIRST_NAME,MIDDLE_NAME|MI... EMP_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,GENDER, EMP_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,GENDER, EMP_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,GENDER, [
   {
       "two_column_flag": "1",
      ...		 NULL NULL [
   {
       "two_column_flag": "1",
      ...		 NULL NULL [
   {
       "two_column_flag": "1",
      ...		 NULL NULL NULL NULL NULL NULL NULL 2022-11-03 21:28:36 kahfi.resmana 2022-11-04 18:31:28 kahfi.resmana NULL NULL 0 Employee Information Employee Information Employee Information 1
With selected: With selected:
|
|
|
|
Filter rows:
Sort by key:
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