Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: kikko
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 :

Database structure

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

Documentation Show or hide a column displaying the charset for all 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.
Filters
Table Ascending Descending Action Rows May be approximate. Click on the number to get the exact count. See FAQ 3.11. Type Collation Size Overhead
activity ~71,308 InnoDB utf8_unicode_ci 9.5 MiB -
activity_v2 62,411 InnoDB utf8_general_ci 6.5 MiB -
adminuser 8 MyISAM utf8_unicode_ci 2.3 KiB -
broker 35 MyISAM utf8_unicode_ci 6.8 KiB -
citrix_broker 510 InnoDB utf8_general_ci 64.0 KiB -
citrix_customer 9,183 InnoDB utf8_general_ci 1.5 MiB -
contacts 14 MyISAM utf8_unicode_ci 2.8 KiB -
document_table 3,432 MyISAM utf8_unicode_ci 638.7 KiB 56 B
document_table_bk 3,420 MyISAM utf8_unicode_ci 630.9 KiB -
ghk_removal 293 InnoDB utf8_unicode_ci 64.0 KiB -
item_gmajor 13 MyISAM utf8_unicode_ci 2.3 KiB -
kcc_ref 37 MyISAM utf8_unicode_ci 3.5 KiB -
kcc_references 103 MyISAM utf8_unicode_ci 5.9 KiB -
kosher 55 MyISAM utf8_unicode_ci 12.8 KiB -
kosher_ukd 164 MyISAM utf8_unicode_ci 32.4 KiB -
kosher_ukd_bk 163 MyISAM utf8_unicode_ci 33.1 KiB -
ksu_new_account 795 InnoDB utf8_unicode_ci 96.0 KiB -
kwikee 312 InnoDB utf8_unicode_ci 80.0 KiB -
level_1 7 MyISAM utf8_unicode_ci 2.4 KiB -
level_2 38 MyISAM utf8_unicode_ci 4.8 KiB -
level_3 196 MyISAM utf8_unicode_ci 17.6 KiB -
level_3_bk 195 MyISAM utf8_unicode_ci 17.6 KiB -
level_4 589 MyISAM utf8_unicode_ci 61.2 KiB -
message 1 MyISAM utf8_unicode_ci 2.5 KiB -
new_products 28 MyISAM utf8_unicode_ci 4.0 KiB -
page_description 56 MyISAM utf8_unicode_ci 22.2 KiB -
product_images 5,835 InnoDB utf8_unicode_ci 1.5 MiB -
product_images_bk 5,769 InnoDB utf8_unicode_ci 1.5 MiB -
product_images_conversion 31 InnoDB utf8_unicode_ci 16.0 KiB -
product_images_ws 8,588 InnoDB utf8_unicode_ci 3.5 MiB -
product_items 487 MyISAM utf8_unicode_ci 301.8 KiB -
product_kimages 2,145 InnoDB utf8_unicode_ci 1.5 MiB -
readme 1 InnoDB utf8_general_ci 16.0 KiB -
roadmap 753 InnoDB utf8_unicode_ci 160.0 KiB -
roadmap_note 579 InnoDB utf8_unicode_ci 112.0 KiB -
selections 833 InnoDB utf8_unicode_ci 192.0 KiB -
spec_kcc 31 MyISAM utf8_unicode_ci 3.1 KiB -
spec_sheets 180 MyISAM utf8_unicode_ci 43.3 KiB 208 B
spec_sheets_bk 181 MyISAM utf8_unicode_ci 42.7 KiB -
user 1,126 MyISAM utf8_unicode_ci 168.2 KiB -
user_bk 961 MyISAM utf8_unicode_ci 136.7 KiB -
user_login_log ~61,883 InnoDB utf8_general_ci 7.5 MiB -
user_onetime_pwd 57,742 InnoDB utf8_general_ci 5.5 MiB -
user_validation 1 MyISAM utf8_unicode_ci 2.0 KiB -
_secured_ip 26 MyISAM utf8_general_ci 3.5 KiB -
45 tables Sum ~300,518 InnoDB utf8_general_ci 41.6 MiB 264 B

Create table
Name:
Number of columns: