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 :
Table structure
Settings for the table structure (list of columns).
Table structure
Documentation Whether the table structure actions should be hidden. Restore default value
Documentation Whether column comments should be shown in table structure view Restore default value
Default transformations
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page. Restore default value

bike_measurements

# Name Type Collation Attributes Null Default Comments Extra Action
1 int(11) No None AUTO_INCREMENT Change Change Drop Drop
2 int(11) No None Change Change Drop Drop
3 decimal(8,2) Yes NULL Change Change Drop Drop
4 decimal(8,2) Yes NULL Change Change Drop Drop
5 decimal(8,2) Yes NULL Change Change Drop Drop
6 decimal(8,2) Yes NULL Change Change Drop Drop
7 decimal(5,2) Yes NULL Change Change Drop Drop
8 decimal(5,2) Yes NULL Change Change Drop Drop
9 decimal(8,2) Yes NULL Change Change Drop Drop
10 decimal(8,2) Yes NULL Change Change Drop Drop
11 decimal(8,2) Yes NULL Change Change Drop Drop
12 decimal(8,2) Yes NULL Change Change Drop Drop
13 decimal(8,2) Yes NULL Change Change Drop Drop
14 decimal(8,2) Yes NULL Change Change Drop Drop
15 decimal(8,2) Yes NULL Change Change Drop Drop
16 decimal(5,2) Yes NULL Change Change Drop Drop
17 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
18 decimal(6,2) Yes NULL Change Change Drop Drop
19 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
20 decimal(4,2) Yes NULL Change Change Drop Drop
21 decimal(6,2) Yes NULL Change Change Drop Drop
22 decimal(5,2) Yes NULL Change Change Drop Drop
23 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
24 decimal(6,2) Yes NULL Change Change Drop Drop
25 decimal(6,2) Yes NULL Change Change Drop Drop
26 decimal(6,2) Yes NULL Change Change Drop Drop
27 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
28 decimal(5,2) Yes NULL Change Change Drop Drop
29 decimal(6,2) Yes NULL Change Change Drop Drop
30 decimal(5,2) Yes NULL Change Change Drop Drop
31 decimal(6,2) Yes NULL Change Change Drop Drop
32 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
33 decimal(6,2) Yes NULL Change Change Drop Drop
34 decimal(6,2) Yes NULL Change Change Drop Drop
35 decimal(6,2) Yes NULL Change Change Drop Drop
36 decimal(6,2) Yes NULL Change Change Drop Drop
37 decimal(5,2) Yes NULL Change Change Drop Drop
38 decimal(5,2) Yes NULL Change Change Drop Drop
39 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
40 decimal(5,2) Yes NULL Change Change Drop Drop
41 decimal(5,2) Yes NULL Change Change Drop Drop
42 decimal(5,2) Yes NULL Change Change Drop Drop
43 decimal(5,2) Yes NULL Change Change Drop Drop
44 decimal(5,2) Yes NULL Change Change Drop Drop
45 decimal(5,2) Yes NULL Change Change Drop Drop
46 decimal(4,1) Yes NULL Change Change Drop Drop
47 decimal(4,1) Yes NULL Change Change Drop Drop
48 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
49 decimal(5,2) Yes NULL Change Change Drop Drop
50 decimal(4,2) Yes NULL Change Change Drop Drop
51 decimal(4,2) Yes NULL Change Change Drop Drop
52 decimal(5,2) Yes NULL Change Change Drop Drop
53 decimal(5,2) Yes NULL Change Change Drop Drop
54 decimal(5,2) Yes NULL Change Change Drop Drop
55 decimal(5,2) Yes NULL Change Change Drop Drop
56 decimal(6,2) Yes NULL Change Change Drop Drop
57 decimal(8,2) Yes NULL Change Change Drop Drop
58 decimal(8,2) Yes NULL Change Change Drop Drop
59 timestamp Yes NULL ON UPDATE CURRENT_TIMESTAMP() Change Change Drop Drop
60 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
61 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
62 int(4) Yes NULL Change Change Drop Drop
63 int(4) Yes NULL Change Change Drop Drop
64 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
65 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
66 decimal(5,1) Yes NULL Change Change Drop Drop
67 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
68 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
69 int(4) Yes NULL Change Change Drop Drop
70 int(4) Yes NULL Change Change Drop Drop
71 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
72 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
73 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
74 varchar(100) utf8mb4_general_ci Yes NULL Change Change Drop Drop
75 int(4) Yes NULL Change Change Drop Drop
With selected: With selected:

Add column  Add column(s)  
Indexes Documentation
Action Keyname Type Unique Packed Column Cardinality Collation Null Comment
Edit Edit Rename Rename Drop Drop PRIMARY BTREE Yes No id 4 A No
Edit Edit Rename Rename Drop Drop bike_id BTREE Yes No bike_id 4 A No
Create an index on columns
Partitions Documentation
Information
Space usage
Data 16.0 KiB
Index 16.0 KiB
Overhead 0 B
Effective 32.0 KiB
Total 32.0 KiB
Optimize table Optimize table
Row statistics
Format dynamic
Collation utf8mb4_general_ci
Next autoindex 5
Creation Jun 08, 2026 at 10:59 PM
Last update Aug 20, 2026 at 09:44 PM
Last check Aug 23, 2026 at 10:05 PM