Drop files here

SQL upload ( 0 ) x-

Server: localhost »Database: herp »Table: addmrn
Page-related settingsClick on the bar to scroll to top of page
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
xxxxxxxxxx
 
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).

Documentation Whether the table structure actions should be hidden.
# Name Type Collation Attributes Null Default Extra Action
1 int(11) No None AUTO_INCREMENT
2 varchar(40) latin1_swedish_ci Yes NULL
3 date Yes NULL
4 date Yes NULL
5 varchar(30) latin1_swedish_ci Yes NULL
6 varchar(20) latin1_swedish_ci Yes NULL
7 varchar(50) latin1_swedish_ci Yes NULL
8 varchar(10) latin1_swedish_ci Yes NULL
9 varchar(50) latin1_swedish_ci Yes NULL
10 varchar(30) latin1_swedish_ci Yes NULL
11 varchar(30) latin1_swedish_ci Yes NULL
12 date Yes NULL
13 varchar(40) latin1_swedish_ci Yes NULL
14 int(6) Yes NULL
15 varchar(10) latin1_swedish_ci Yes NULL
16 varchar(10) latin1_swedish_ci Yes NULL
17 date Yes NULL
18 varchar(10) latin1_swedish_ci Yes NULL
19 date Yes NULL
20 varchar(30) latin1_swedish_ci Yes NULL
21 varchar(20) latin1_swedish_ci Yes NULL
22 varchar(10) latin1_swedish_ci Yes NULL
23 varchar(10) latin1_swedish_ci Yes NULL
24 varchar(10) latin1_swedish_ci Yes NULL
25 date Yes NULL
26 varchar(50) latin1_swedish_ci Yes NULL
27 varchar(50) latin1_swedish_ci Yes NULL
28 varchar(100) latin1_swedish_ci Yes NULL
29 text latin1_swedish_ci Yes NULL
30 text latin1_swedish_ci Yes NULL
31 varchar(20) latin1_swedish_ci Yes NULL
32 varchar(20) latin1_swedish_ci Yes NULL
33 varchar(30) latin1_swedish_ci Yes NULL
34 double(10,2) Yes NULL
35 double(10,2) Yes NULL
36 double(10,2) Yes NULL
37 double(10,2) Yes NULL
38 varchar(20) latin1_swedish_ci Yes NULL
39 double(10,2) Yes NULL
40 double(10,2) Yes NULL
41 double(10,2) Yes NULL
42 double(10,2) Yes NULL
43 double(10,2) Yes NULL
44 double(10,2) Yes NULL
45 varchar(5) latin1_swedish_ci Yes NULL
46 varchar(20) latin1_swedish_ci Yes NULL
47 varchar(30) latin1_swedish_ci Yes NULL
48 varchar(10) latin1_swedish_ci Yes N
49 varchar(30) latin1_swedish_ci Yes NULL
50 date Yes NULL
51 int(10) Yes 0
52 int(10) Yes NULL
53 double(10,2) Yes NULL
54 int(25) Yes NULL
55 int(25) Yes NULL
56 varchar(255) latin1_swedish_ci Yes NULL
57 int(10) No None
58 double(16,2) No None
59 double(16,2) No None
60 double(16,2) No None
61 double(16,2) No None
62 double(16,2) No None
63 double(16,2) No None
64 double(16,2) No None
65 double(16,2) No None
66 double(16,2) No None
67 double(16,2) No None
68 double(16,2) No None
69 double(16,2) No None
70 varchar(255) latin1_swedish_ci No None
71 varchar(255) latin1_swedish_ci No None
72 int(10) No None
73 date No None
74 varchar(255) latin1_swedish_ci No Consolidated
75 varchar(255) latin1_swedish_ci No None
76 varchar(10) latin1_swedish_ci Yes 0
77 double(10,2) Yes NULL
78 double(10,2) Yes NULL
79 varchar(200) latin1_swedish_ci Yes NULL
80 datetime Yes NULL
81 int(11) Yes NULL
82 double(10,2) Yes NULL
83 double(10,2) No None
84 double(10,2) No None

Add column  Add column(s)  
Information
Space usage
Data 3.5 MiB
Index 0 B
Total 3.5 MiB
Row statistics
Format Compact
Collation latin1_swedish_ci
Next autoindex 9,300
Creation Aug 28, 2024 at 12:35 PM