Letakkan berkas disini

SQL upload ( 0 ) x -

Pengaturan Terkait dengan Halaman Klik pada bar untuk menggulir ke atas halaman
Tekan Ctrl+Enter untuk menjalankan kueri Press Enter to execute query
ascending
descending
Order:
Men-Debug SQL
Jumlah
Execution order
Time taken
Order by:
Group queries
Ungroup queries
Tampilkan Buka Show trace Hide trace Jumlah Time taken
Bookmark
Segarkan
Tambah
Tidak ada penanda
Tambah bookmark
Opsi
Kembalikan nilai bawaan





Tampilkan Buka Kueri ulang Ubah Jelaskan Profil Bookmarks Kueri gagal Basis data : Waktu eksekusi kueri :
Belum ada nama *
v Show/Hide tables list View in fullscreen Tambahkan tabel dari database lainya New page Buka halaman Simpan halaman Simpan halaman sebagai Delete pages Buat tabel Create relationship Pilih kolom untuk ditampilkan Muat ulang Bantuan Tautan angular / Tautan langsung Lekatkan kepada kisi v Small/Big All Toggle small/big Toggle relationship lines Export schema > Pindahkan Menu > Sematkan teks
Number of tables: 0
v phpmyadmin pma__bookmark
* id : int(10) unsigned
* dbase : varchar(255)
* user : varchar(255)
* label : varchar(255)
* query : text
v phpmyadmin pma__central_columns
* db_name : varchar(64)
* col_name : varchar(64)
* col_type : varchar(64)
* col_length : text
* col_collation : varchar(64)
* col_isNull : tinyint(1)
* col_extra : varchar(255)
* col_default : text
v phpmyadmin pma__column_info
* id : int(5) unsigned
* db_name : varchar(64)
* table_name : varchar(64)
* column_name : varchar(64)
* comment : varchar(255)
* mimetype : varchar(255)
* transformation : varchar(255)
* transformation_options : varchar(255)
* input_transformation : varchar(255)
* input_transformation_options : varchar(255)
v phpmyadmin pma__designer_settings
* username : varchar(64)
* settings_data : text
v phpmyadmin pma__export_templates
* id : int(5) unsigned
* username : varchar(64)
* export_type : varchar(10)
* template_name : varchar(64)
* template_data : text
v phpmyadmin pma__favorite
* username : varchar(64)
* tables : text
v phpmyadmin pma__history
* id : bigint(20) unsigned
* username : varchar(64)
* db : varchar(64)
* table : varchar(64)
* timevalue : timestamp
* sqlquery : text
v phpmyadmin pma__navigationhiding
* username : varchar(64)
* item_name : varchar(64)
* item_type : varchar(64)
* db_name : varchar(64)
* table_name : varchar(64)
v phpmyadmin pma__pdf_pages
* db_name : varchar(64)
* page_nr : int(10) unsigned
* page_descr : varchar(50)
v phpmyadmin pma__recent
* username : varchar(64)
* tables : text
v phpmyadmin pma__relation
* master_db : varchar(64)
* master_table : varchar(64)
* master_field : varchar(64)
* foreign_db : varchar(64)
* foreign_table : varchar(64)
* foreign_field : varchar(64)
v phpmyadmin pma__savedsearches
* id : int(5) unsigned
* username : varchar(64)
* db_name : varchar(64)
* search_name : varchar(64)
* search_data : text
v phpmyadmin pma__table_coords
* db_name : varchar(64)
* table_name : varchar(64)
* pdf_page_number : int(11)
* x : float unsigned
* y : float unsigned
v phpmyadmin pma__table_info
* db_name : varchar(64)
* table_name : varchar(64)
* display_field : varchar(64)
v phpmyadmin pma__table_uiprefs
* username : varchar(64)
* db_name : varchar(64)
* table_name : varchar(64)
* prefs : text
* last_update : timestamp
v phpmyadmin pma__tracking
* db_name : varchar(64)
* table_name : varchar(64)
* version : int(10) unsigned
* date_created : datetime
* date_updated : datetime
* schema_snapshot : text
* schema_sql : text
* data_sql : longtext
* tracking : set('UPDATE','REPLACE','INSERT','DELETE','TRUNCATE','CREATE DATABASE','ALTER DATABASE','DROP DATABASE','CREATE TABLE','ALTER TABLE','RENAME TABLE','DROP TABLE','CREATE INDEX','DROP INDEX','CREATE VIEW','ALTER VIEW','DROP VIEW')
* tracking_active : int(1) unsigned
v phpmyadmin pma__userconfig
* username : varchar(64)
* timevalue : timestamp
* config_data : text
v phpmyadmin pma__usergroups
* usergroup : varchar(64)
* tab : varchar(64)
* allowed : enum('Y','N')
v phpmyadmin pma__users
* username : varchar(64)
* usergroup : varchar(64)
Create relationship
FOREIGN KEY
on delete
on update
Delete relationship