• There are no recent tables.
  • There are no favorite tables.
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
Options
Set default





Collapse Expand Requery Edit Explain Profiling Query failed Database : Queried time :
Choose which details to show in the database structure (list of tables).
Database structure
Documentation Show or hide a column displaying the charset for all tables. Restore default value
Documentation Show or hide a column displaying the comments for all tables. Restore default value
Documentation Show or hide a column displaying the Creation timestamp for all tables. Restore default value
Documentation Show or hide a column displaying the Last update timestamp for all tables. Restore default value
Documentation Show or hide a column displaying the Last check timestamp for all tables. Restore default value
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
bioformat   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3 MyISAM utf8_general_ci 8.1 KiB -
biotype   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 9 MyISAM utf8_general_ci 8.2 KiB -
commands   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1.0 KiB -
devicecommands   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,530 MyISAM utf8_general_ci 4.6 MiB -
deviceerrormessages   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 69 MyISAM utf8_general_ci 692.2 KiB -
devicegroup   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 10 MyISAM utf8_general_ci 9.4 KiB -
devicelogs   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 45.4 KiB 35.4  KiB
devicelogsinfobl   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1.0 KiB -
devicelogs_1_2019   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,683 InnoDB utf8mb4_general_ci 832.0 KiB -
devicelogs_1_2020   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,529 InnoDB utf8mb4_general_ci 1.9 MiB -
devicelogs_1_2021   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,693 InnoDB utf8mb4_general_ci 656.0 KiB -
devicelogs_1_2022   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,463 InnoDB utf8mb4_general_ci 576.0 KiB -
devicelogs_1_2023   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,807 InnoDB utf8mb4_general_ci 720.0 KiB -
devicelogs_1_2024   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,889 InnoDB utf8mb4_general_ci 720.0 KiB -
devicelogs_1_2026   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,925 InnoDB utf8mb4_general_ci 512.0 KiB -
devicelogs_2_2019   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,642 InnoDB utf8mb4_general_ci 1.8 MiB -
devicelogs_2_2020   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,769 InnoDB utf8mb4_general_ci 1.9 MiB -
devicelogs_2_2021   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,584 InnoDB utf8mb4_general_ci 704.0 KiB -
devicelogs_2_2022   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,089 InnoDB utf8mb4_general_ci 656.0 KiB -
devicelogs_2_2023   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,857 InnoDB utf8mb4_general_ci 720.0 KiB -
devicelogs_2_2024   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,797 InnoDB utf8mb4_general_ci 720.0 KiB -
devicelogs_2_2026   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,071 InnoDB utf8mb4_general_ci 704.0 KiB -
devicelogs_3_2019   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,252 InnoDB utf8mb4_general_ci 528.0 KiB -
devicelogs_3_2020   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,175 InnoDB utf8mb4_general_ci 400.0 KiB -
devicelogs_3_2021   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,137 InnoDB utf8mb4_general_ci 768.0 KiB -
devicelogs_3_2022   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,404 InnoDB utf8mb4_general_ci 592.0 KiB -
devicelogs_3_2023   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,511 InnoDB utf8mb4_general_ci 720.0 KiB -
devicelogs_3_2024   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,176 InnoDB utf8mb4_general_ci 560.0 KiB -
devicelogs_3_2026   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,739 InnoDB utf8mb4_general_ci 576.0 KiB -
devicelogs_4_2019   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,032 InnoDB utf8mb4_general_ci 832.0 KiB -
devicelogs_4_2020   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1 InnoDB utf8mb4_general_ci 32.0 KiB -
devicelogs_4_2021   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,075 InnoDB utf8mb4_general_ci 272.0 KiB -
devicelogs_4_2022   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,363 InnoDB utf8mb4_general_ci 464.0 KiB -
devicelogs_4_2023   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,059 InnoDB utf8mb4_general_ci 656.0 KiB -
devicelogs_4_2024   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,786 InnoDB utf8mb4_general_ci 592.0 KiB -
devicelogs_4_2026   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,806 InnoDB utf8mb4_general_ci 400.0 KiB -
devicelogs_5_2019   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 9,138 InnoDB utf8mb4_general_ci 1.9 MiB -
devicelogs_5_2020   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 115 InnoDB utf8mb4_general_ci 32.0 KiB -
devicelogs_5_2022   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,935 InnoDB utf8mb4_general_ci 448.0 KiB -
devicelogs_5_2023   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 8,685 InnoDB utf8mb4_general_ci 1.8 MiB -
devicelogs_5_2024   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 8,810 InnoDB utf8mb4_general_ci 1.8 MiB -
devicelogs_5_2025   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,796 InnoDB utf8mb4_general_ci 496.0 KiB -
devicelogs_5_2026   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,734 InnoDB utf8mb4_general_ci 1.7 MiB -
devicelogs_6_2018   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 30 InnoDB utf8mb4_general_ci 32.0 KiB -
devicelogs_6_2019   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 8,058 InnoDB utf8mb4_general_ci 1.8 MiB -
devicelogs_6_2020   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 131 InnoDB utf8mb4_general_ci 32.0 KiB -
devicelogs_6_2022   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,328 InnoDB utf8mb4_general_ci 560.0 KiB -
devicelogs_6_2023   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,909 InnoDB utf8mb4_general_ci 1.7 MiB -
devicelogs_6_2024   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,900 InnoDB utf8mb4_general_ci 1.7 MiB -
devicelogs_6_2025   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,941 InnoDB utf8mb4_general_ci 1.7 MiB -
devicelogs_6_2026   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,323 InnoDB utf8mb4_general_ci 704.0 KiB -
devicelogs_7_2018   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 58 InnoDB utf8mb4_general_ci 32.0 KiB -
devicelogs_7_2019   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,146 InnoDB utf8mb4_general_ci 272.0 KiB -
devicelogs_7_2020   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 19 InnoDB utf8mb4_general_ci 32.0 KiB -
devicelogs_7_2021   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 38 InnoDB utf8mb4_general_ci 32.0 KiB -
devicelogs_7_2022   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,267 InnoDB utf8mb4_general_ci 464.0 KiB -
devicelogs_7_2023   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,107 InnoDB utf8mb4_general_ci 256.0 KiB -
devicelogs_7_2024   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,925 InnoDB utf8mb4_general_ci 448.0 KiB -
devicelogs_7_2025   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,401 InnoDB utf8mb4_general_ci 384.0 KiB -
devicelogs_7_2026   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 1,662 InnoDB utf8mb4_general_ci 224.0 KiB -
devicelogs_8_2018   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 3,904 InnoDB utf8mb4_general_ci 480.0 KiB -
devicelogs_8_2019   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,811 InnoDB utf8mb4_general_ci 672.0 KiB -
devicelogs_8_2020   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 51 InnoDB utf8mb4_general_ci 32.0 KiB -
devicelogs_8_2021   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 40 InnoDB utf8mb4_general_ci 32.0 KiB -
devicelogs_8_2022   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,472 InnoDB utf8mb4_general_ci 576.0 KiB -
devicelogs_8_2023   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,709 InnoDB utf8mb4_general_ci 688.0 KiB -
devicelogs_8_2024   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,144 InnoDB utf8mb4_general_ci 560.0 KiB -
devicelogs_8_2025   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,820 InnoDB utf8mb4_general_ci 480.0 KiB -
devicelogs_8_2026   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,571 InnoDB utf8mb4_general_ci 720.0 KiB -
devicelogs_9_2018   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,571 InnoDB utf8mb4_general_ci 1.8 MiB -
devicelogs_9_2019   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 8,070 InnoDB utf8mb4_general_ci 1.9 MiB -
devicelogs_9_2020   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,427 InnoDB utf8mb4_general_ci 304.0 KiB -
devicelogs_9_2021   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,514 InnoDB utf8mb4_general_ci 496.0 KiB -
devicelogs_9_2022   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,747 InnoDB utf8mb4_general_ci 1.7 MiB -
devicelogs_9_2023   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,976 InnoDB utf8mb4_general_ci 736.0 KiB -
devicelogs_9_2024   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,662 InnoDB utf8mb4_general_ci 688.0 KiB -
devicelogs_9_2025   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,787 InnoDB utf8mb4_general_ci 560.0 KiB -
devicelogs_9_2026   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,736 InnoDB utf8mb4_general_ci 320.0 KiB -
devicelogs_10_2018   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,608 InnoDB utf8mb4_general_ci 704.0 KiB -
devicelogs_10_2019   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,755 InnoDB utf8mb4_general_ci 688.0 KiB -
devicelogs_10_2020   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,060 InnoDB utf8mb4_general_ci 464.0 KiB -
devicelogs_10_2021   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,218 InnoDB utf8mb4_general_ci 464.0 KiB -
devicelogs_10_2022   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,313 InnoDB utf8mb4_general_ci 560.0 KiB -
devicelogs_10_2023   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,756 InnoDB utf8mb4_general_ci 608.0 KiB -
devicelogs_10_2024   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,537 InnoDB utf8mb4_general_ci 576.0 KiB -
devicelogs_10_2025   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,619 InnoDB utf8mb4_general_ci 640.0 KiB -
devicelogs_11_2018   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,717 InnoDB utf8mb4_general_ci 1.8 MiB -
devicelogs_11_2019   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 8,119 InnoDB utf8mb4_general_ci 1.9 MiB -
devicelogs_11_2020   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,582 InnoDB utf8mb4_general_ci 1.9 MiB -
devicelogs_11_2021   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,174 InnoDB utf8mb4_general_ci 640.0 KiB -
devicelogs_11_2022   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,487 InnoDB utf8mb4_general_ci 1.7 MiB -
devicelogs_11_2023   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,872 InnoDB utf8mb4_general_ci 1.7 MiB -
devicelogs_11_2024   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,872 InnoDB utf8mb4_general_ci 1.7 MiB -
devicelogs_11_2025   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,108 InnoDB utf8mb4_general_ci 704.0 KiB -
devicelogs_12_2018   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,126 InnoDB utf8mb4_general_ci 592.0 KiB -
devicelogs_12_2019   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2,879 InnoDB utf8mb4_general_ci 384.0 KiB -
devicelogs_12_2020   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,714 InnoDB utf8mb4_general_ci 864.0 KiB -
devicelogs_12_2021   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,342 InnoDB utf8mb4_general_ci 576.0 KiB -
devicelogs_12_2022   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 5,994 InnoDB utf8mb4_general_ci 640.0 KiB -
devicelogs_12_2023   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 6,220 InnoDB utf8mb4_general_ci 640.0 KiB -
devicelogs_12_2024   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 4,758 InnoDB utf8mb4_general_ci 512.0 KiB -
devicelogs_12_2025   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 7,542 InnoDB utf8mb4_general_ci 1.7 MiB -
devicelogs_processed   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 656,612 MyISAM utf8_general_ci 39.0 MiB -
deviceoperationlogs   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 201,160 MyISAM utf8_general_ci 11.3 MiB -
deviceoperationlogtypes   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 0 MyISAM utf8_general_ci 1.0 KiB -
devices   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 2 MyISAM utf8_general_ci 8.6 KiB 332  B
employees   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 501 MyISAM utf8_general_ci 91.3 KiB -
employeesbio   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 589 MyISAM utf8_general_ci 831.2 KiB -
timezone   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 50 MyISAM utf8_general_ci 14.1 KiB -
users   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 9 MyISAM utf8_general_ci 3.7 KiB -
verificationmode   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 26 MyISAM utf8_general_ci 1.6 KiB -
verificationtype   Browse Browse Structure Structure Search Search Insert Insert Empty Empty Drop Drop 15 MyISAM utf8_general_ci 2.5 KiB -
112 tables Sum 1,367,739 InnoDB utf8mb4_general_ci 130.2 MiB 35.8 KiB
With selected: / Check tables having overhead

Data dictionary Data dictionary

Create new table Create new table