Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1:3309 »Database: mysql
Page-related settingsClick on the bar to scroll to top of page
Press Ctrl+Enter to execute queryPress 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:

Database structure

Choose which details to show in the database structure (list of tables).

Documentation Show or hide a column displaying the comments for all tables.
Documentation Show or hide a column displaying the Creation timestamp for all tables.
Documentation Show or hide a column displaying the Last update timestamp for all tables.
Documentation Show or hide a column displaying the Last check timestamp for all tables.
Table AscendingDescending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Size Overhead
agama 5 InnoDB latin1_swedish_ci 96 KiB -
applications 2 InnoDB latin1_swedish_ci 48 KiB -
app_installed 59 InnoDB latin1_swedish_ci 32 KiB -
auth_assignment 9 InnoDB utf8_unicode_ci 48 KiB -
auth_data 108,852 InnoDB latin1_swedish_ci 33.2 MiB -
auth_header 9,856 InnoDB latin1_swedish_ci 6.8 MiB -
auth_item 1,168 InnoDB utf8_unicode_ci 448 KiB -
auth_item_child 111 InnoDB utf8_unicode_ci 64 KiB -
auth_rule 0 InnoDB utf8_unicode_ci 48 KiB -
bacaditempat 53 InnoDB latin1_swedish_ci 112 KiB -
bacaditempat_locations 0 InnoDB latin1_swedish_ci 80 KiB -
backup 2 InnoDB latin1_swedish_ci 32 KiB -
bibidavailable 0 InnoDB latin1_swedish_ci 64 KiB -
bookinglogs 3 InnoDB latin1_swedish_ci 32 KiB -
bookmark 0 InnoDB latin1_swedish_ci 48 KiB -
branchs 43 InnoDB latin1_swedish_ci 64 KiB -
cardformats 5 InnoDB latin1_swedish_ci 48 KiB -
catalogfiles 28 InnoDB latin1_swedish_ci 128 KiB -
catalogs 116 InnoDB latin1_swedish_ci 464 KiB -
catalogstaging 0 InnoDB latin1_swedish_ci 48 KiB -
catalog_ruas 2,013 InnoDB latin1_swedish_ci 800 KiB -
catalog_subruas 2,711 InnoDB latin1_swedish_ci 896 KiB -
cetak_bebas_pustaka 2 InnoDB latin1_swedish_ci 80 KiB -
cetak_kartu_anggota 5 InnoDB latin1_swedish_ci 80 KiB -
checkpoint_locations 0 InnoDB latin1_swedish_ci 80 KiB -
collectioncategorys 8 InnoDB latin1_swedish_ci 96 KiB -
collectioncategorysdefault 12 InnoDB latin1_swedish_ci 80 KiB -
collectionloanextends 0 InnoDB latin1_swedish_ci 112 KiB -
collectionloanitems 28 InnoDB latin1_swedish_ci 176 KiB -
collectionloans 22 InnoDB latin1_swedish_ci 80 KiB -
collectionlocations 0 InnoDB latin1_swedish_ci 48 KiB -
collectionmedias 47 InnoDB latin1_swedish_ci 112 KiB -
collectionrules 5 InnoDB latin1_swedish_ci 96 KiB -
collectionrulesitems 0 InnoDB latin1_swedish_ci 64 KiB -
collections 65 InnoDB latin1_swedish_ci 464 KiB -
collectionsources 7 InnoDB latin1_swedish_ci 96 KiB -
collectionstatus 11 InnoDB latin1_swedish_ci 96 KiB -
colloclib 0 InnoDB latin1_swedish_ci 80 KiB -
columns_priv 29 MyISAM utf8_bin 37.4 KiB 1,002 B
column_stats 0 MyISAM utf8_bin 4 KiB -
currency 184 InnoDB latin1_swedish_ci 128 KiB -
daemons 0 MyISAM utf8_general_ci 1 KiB -
db 3 MyISAM utf8_bin 12.1 KiB 1,264 B
departments 3 InnoDB latin1_swedish_ci 128 KiB -
djkn_data 0 InnoDB latin1_swedish_ci 64 KiB -
event 0 MyISAM utf8_general_ci 20.6 KiB 16.6 KiB
favorite 6 InnoDB latin1_swedish_ci 48 KiB -
fielddatas 865 InnoDB latin1_swedish_ci 160 KiB -
fieldgroups 2 InnoDB latin1_swedish_ci 48 KiB -
fieldindicator1s 302 InnoDB latin1_swedish_ci 64 KiB -
fieldindicator2s 254 InnoDB latin1_swedish_ci 64 KiB -
fields 138 InnoDB latin1_swedish_ci 128 KiB -
formats 2 InnoDB latin1_swedish_ci 48 KiB -
func 0 MyISAM utf8_bin 1 KiB -
gammu 1 MyISAM utf8_general_ci 1 KiB -
general_log 0 CSV utf8_general_ci unknown -
groupguesses 5 InnoDB latin1_swedish_ci 96 KiB -
gtid_slave_pos 0 InnoDB latin1_swedish_ci 16 KiB -
help_category 40 MyISAM utf8_general_ci 4.1 KiB -
help_keyword 475 MyISAM utf8_general_ci 108.4 KiB -
help_relation 1,059 MyISAM utf8_general_ci 28.3 KiB -
help_topic 529 MyISAM utf8_general_ci 497.5 KiB -
historydata 231 InnoDB latin1_general_ci 432 KiB -
holidays 32 InnoDB latin1_swedish_ci 48 KiB -
host 0 MyISAM utf8_bin 2 KiB -
inbox 0 MyISAM utf8_general_ci 1 KiB -
index_stats 0 MyISAM utf8_bin 4 KiB -
innodb_index_stats 4,672 InnoDB utf8_bin 1.2 MiB -
innodb_table_stats 246 InnoDB utf8_bin 48 KiB -
ndb_binlog_index 0 MyISAM latin1_swedish_ci 1 KiB -
plugin 0 MyISAM utf8_general_ci 1 KiB -
proc 55 MyISAM utf8_general_ci 303.1 KiB 27.2 KiB
procs_priv 0 MyISAM utf8_bin 11.2 KiB 1,234 B
proxies_priv 1 MyISAM utf8_bin 11.2 KiB -
roles_mapping 0 MyISAM utf8_bin 4 KiB -
servers 0 MyISAM utf8_general_ci 1 KiB -
slave_master_info 0 InnoDB utf8_general_ci 16 KiB -
slave_relay_log_info 0 InnoDB utf8_general_ci 16 KiB -
slave_worker_info 0 InnoDB utf8_general_ci 16 KiB -
slow_log 2 CSV utf8_general_ci unknown -
tables_priv 0 MyISAM utf8_bin 11.2 KiB 1,235 B
table_stats 0 MyISAM utf8_bin 2 KiB -
time_zone 0 MyISAM utf8_general_ci 1 KiB -
time_zone_leap_second 0 MyISAM utf8_general_ci 1 KiB -
time_zone_name 0 MyISAM utf8_general_ci 1 KiB -
time_zone_transition 0 MyISAM utf8_general_ci 1 KiB -
time_zone_transition_type 0 MyISAM utf8_general_ci 1 KiB -
user 6 MyISAM utf8_bin 4.5 KiB 96 B
88 tables Sum 134,390 InnoDB latin1_swedish_ci 49.1 MiB 48.5 KiB

  Create table
Name:
Number of columns: