Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: stms
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   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 171,325 MyISAM utf8_unicode_ci 9.3 MiB -
alc_zone   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 166 MyISAM utf8_unicode_ci 14.7 KiB -
blocks   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 74 MyISAM utf8_unicode_ci 5.2 KiB -
default_email   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 MyISAM utf8_general_ci 2.0 KiB -
ext_samp   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 12,600 MyISAM utf8_unicode_ci 715.4 KiB -
lab_type   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7 MyISAM utf8_unicode_ci 2.3 KiB -
moromi_tank   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 14,337 MyISAM utf8_unicode_ci 1.1 MiB -
moromi_type   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 13 MyISAM utf8_unicode_ci 2.7 KiB -
moromi_type_new   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 15 MyISAM utf8_unicode_ci 3.0 KiB -
moromi_type_old   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 13 MyISAM utf8_unicode_ci 2.7 KiB -
notification   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,250 MyISAM utf8_general_ci 226.6 KiB -
ph_zone   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 68 MyISAM utf8_unicode_ci 6.1 KiB -
post_comments   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,700 MyISAM utf8_general_ci 280.4 KiB -
sampling   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 92,683 MyISAM utf8_unicode_ci 5.7 MiB -
sampling_nextdate   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 108,756 MyISAM utf8_unicode_ci 7.8 MiB 656 B
user   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 33 MyISAM utf8_unicode_ci 4.2 KiB -
_secured_ip   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 13 MyISAM utf8_general_ci 2.5 KiB -
17 tables Sum 406,054 InnoDB utf8mb4_general_ci 25.3 MiB 656 B
With selected: / Check tables having overhead

Print Print Data dictionary Data dictionary

Create table
Name:
Number of columns: