Drop files here

SQL upload ( 0 ) x -

Page-related settings Click 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 :
Browse mode

Customise browse mode.

Documentation Use only icons, only text or both.
Documentation Use only icons, only text or both.
Documentation Whether a user should be displayed a "show all (rows)" button.
Documentation Number of rows displayed when browsing a result set. If the result set contains more rows, "Previous" and "Next" links will be shown.
Documentation SMART - i.e. descending order for columns of type TIME, DATE, DATETIME and TIMESTAMP, ascending order otherwise.
Documentation Highlight row pointed by the mouse cursor.
Documentation Highlight selected rows.
Documentation
Documentation
Documentation Repeat the headers every X cells, 0 deactivates this feature.
Documentation Maximum number of characters shown in any non-numeric column on browse view.
Documentation These are Edit, Copy and Delete links.
Documentation Whether to show row links even in the absence of a unique key.
Documentation Default sort order for tables with a primary key.
Documentation When browsing tables, the sorting of each table is remembered.
Documentation For display Options
SELECT * FROM `COLLATIONS` ORDER BY `IS_DEFAULT`  ASC 
COLLATION_NAMECHARACTER_SET_NAMEIDIS_DEFAULT Ascending Descending 1IS_COMPILEDSORTLEN
keybcs2_nopad_bin keybcs2 1097 Yes 1
utf8mb4_danish_ci utf8mb4 235 Yes 8
utf16_romanian_ci utf16 104 Yes 8
cp850_nopad_bin cp850 1104 Yes 1
utf32_croatian_mysql561_ci utf32 181 Yes 8
ascii_general_nopad_ci ascii 1035 Yes 1
greek_general_nopad_ci greek 1049 Yes 1
utf8_turkish_ci utf8 201 Yes 8
ucs2_spanish_ci ucs2 135 Yes 8
ucs2_general_nopad_ci ucs2 1059 Yes 1
utf8mb4_unicode_ci utf8mb4 224 Yes 8
cp1251_ukrainian_ci cp1251 23 Yes 1
utf16_croatian_ci utf16 672 Yes 8
utf32_czech_ci utf32 170 Yes 8
latin2_hungarian_ci latin2 21 Yes 1
eucjpms_japanese_nopad_ci eucjpms 1121 Yes 1
euckr_nopad_bin euckr 1109 Yes 1
utf8_unicode_nopad_ci utf8 1216 Yes 8
ucs2_esperanto_ci ucs2 145 Yes 8
cp852_bin cp852 81 Yes 1
utf8mb4_croatian_mysql561_ci utf8mb4 245 Yes 8
utf16_slovak_ci utf16 114 Yes 8
utf32_bin utf32 61 Yes 1
gbk_bin gbk 87 Yes 1
utf8_sinhala_ci utf8 211 Yes 8