Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: ksussg
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
annotation   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 107 MyISAM utf8_unicode_ci 11.5 KiB -
attribute   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 243 MyISAM utf8_unicode_ci 19.6 KiB -
default_email   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7 MyISAM latin1_swedish_ci 2.3 KiB -
log_allergen   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 262 MyISAM utf8_unicode_ci 24.6 KiB -
log_chem1   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 596 MyISAM utf8_unicode_ci 71.8 KiB -
log_chem2   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 404 MyISAM utf8_unicode_ci 43.5 KiB -
log_chem3   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 238 MyISAM utf8_unicode_ci 27.3 KiB -
log_ingredients   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 772 MyISAM utf8_unicode_ci 282.1 KiB -
log_itemformat   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,697 MyISAM utf8_unicode_ci 463.7 KiB -
log_micro   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 507 MyISAM utf8_unicode_ci 56.7 KiB -
log_nutrition   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 926 MyISAM utf8_unicode_ci 139.2 KiB -
log_physchar   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 457 MyISAM utf8_unicode_ci 81.0 KiB 176 B
log_sauceitems   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,215 MyISAM utf8_unicode_ci 96.5 KiB -
post_comments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 246 MyISAM utf8_general_ci 36.3 KiB -
product_item   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,362 MyISAM utf8_unicode_ci 269.5 KiB -
saucecode   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 522 MyISAM utf8_unicode_ci 30.4 KiB -
sauceitem   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 382 MyISAM utf8_unicode_ci 273.6 KiB 168 B
saucetype   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7 MyISAM utf8_unicode_ci 2.1 KiB -
specifications   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,508 MyISAM utf8_unicode_ci 1.3 MiB 20 B
spec_user   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 46 MyISAM utf8_unicode_ci 6.0 KiB -
sp_allergen   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 785 MyISAM utf8_unicode_ci 65.7 KiB -
sp_analysis   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 14,711 MyISAM utf8_unicode_ci 1.7 MiB -
sp_certifications   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,512 MyISAM utf8_unicode_ci 194.8 KiB -
sp_ingredients   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,507 MyISAM utf8_unicode_ci 555.4 KiB -
sp_nutritions   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 43,837 MyISAM utf8_unicode_ci 4.4 MiB -
sp_physchar   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,200 MyISAM utf8_unicode_ci 1.0 MiB -
v_date_code   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 42 MyISAM utf8_unicode_ci 14.9 KiB -
v_item_format   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 847 MyISAM utf8_unicode_ci 171.8 KiB -
v_mfg_loc   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 27 MyISAM utf8_unicode_ci 2.7 KiB -
v_pack_type   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,559 MyISAM utf8_unicode_ci 136.1 KiB -
v_storage_cond   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 15 MyISAM utf8_unicode_ci 4.8 KiB -
_secured_ip   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 10 MyISAM utf8_general_ci 2.4 KiB -
32 tables Sum 89,556 InnoDB utf8mb4_general_ci 11.3 MiB 364 B
With selected: / Check tables having overhead

Print Print Data dictionary Data dictionary

Create table
Name:
Number of columns: