Drop files here

SQL upload ( 0 ) x-

Server: 127.0.0.1 »Database: gpsbeta »Table: tst2021_pgfull
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

Table structure

Settings for the table structure (list of columns).

Documentation Whether the table structure actions should be hidden.
Documentation Whether column comments should be shown in table structure view
Default transformations
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
Documentation Values for options list for default transformations. These will be overwritten if transformation is filled in at table structure page.
# Name Type Collation Attributes Null Default Comments Extra Action
1 int(11) No 0
2 varchar(15) utf8_general_ci Yes NULL
3 int(1) Yes NULL
4 int(2) Yes NULL
5 varchar(150) utf8_general_ci Yes NULL
6 varchar(150) utf8_general_ci Yes NULL
7 varchar(150) utf8_general_ci Yes NULL
8 varchar(150) utf8_general_ci Yes NULL
9 varchar(150) utf8_general_ci Yes NULL
10 int(3) Yes NULL
11 date Yes NULL
12 varchar(5) utf8_general_ci Yes NULL
13 varchar(4) utf8_general_ci Yes NULL
14 varchar(20) utf8_general_ci Yes NULL
15 bigint(10) Yes NULL
16 varchar(1) utf8_general_ci Yes NULL
17 varchar(150) utf8_general_ci Yes NULL
18 varchar(150) utf8_general_ci Yes NULL
19 varchar(150) utf8_general_ci Yes NULL
20 int(6) Yes NULL
21 varchar(50) utf8_general_ci Yes NULL
22 varchar(10) utf8_general_ci Yes NULL
23 varchar(50) utf8_general_ci Yes NULL
24 varchar(2) utf8_general_ci Yes NULL
25 varchar(3) utf8_general_ci Yes NULL
26 varchar(2) utf8_general_ci Yes NULL
27 varchar(10) utf8_general_ci Yes NULL
28 int(2) Yes NULL
29 varchar(150) utf8_general_ci Yes NULL
30 int(7) Yes NULL
31 int(2) Yes NULL
32 varchar(100) utf8_general_ci Yes NULL
33 int(4) Yes NULL
34 int(2) Yes NULL
35 varchar(20) utf8_general_ci Yes NULL
36 varchar(20) utf8_general_ci Yes NULL
37 varchar(100) utf8_general_ci Yes NULL
38 int(7) Yes NULL
39 int(1) Yes NULL
40 varchar(150) utf8_general_ci Yes NULL
41 int(4) Yes NULL
42 int(2) Yes NULL
43 varchar(20) utf8_general_ci Yes NULL
44 varchar(100) utf8_general_ci Yes NULL
45 varchar(150) utf8_general_ci Yes NULL
46 varchar(10) utf8_general_ci Yes NULL
47 int(1) Yes NULL
48 varchar(100) utf8_general_ci Yes NULL
49 int(4) Yes NULL
50 int(2) Yes NULL
51 varchar(4) utf8_general_ci Yes NULL
52 varchar(100) utf8_general_ci Yes NULL
53 varchar(100) utf8_general_ci Yes NULL
54 varchar(10) utf8_general_ci Yes NULL
55 varchar(10) utf8_general_ci Yes NULL
56 varchar(100) utf8_general_ci Yes NULL
57 varchar(10) utf8_general_ci Yes NULL
58 varchar(10) utf8_general_ci Yes NULL
59 varchar(10) utf8_general_ci Yes NULL
60 varchar(100) utf8_general_ci Yes NULL
61 varchar(100) utf8_general_ci Yes NULL
62 varchar(10) utf8_general_ci Yes NULL
63 varchar(10) utf8_general_ci Yes NULL
64 varchar(100) utf8_general_ci Yes NULL
65 varchar(10) utf8_general_ci Yes NULL
66 varchar(10) utf8_general_ci Yes NULL
67 varchar(10) utf8_general_ci Yes NULL
68 varchar(10) utf8_general_ci Yes NULL
69 varchar(10) utf8_general_ci Yes NULL
70 varchar(10) utf8_general_ci Yes NULL
71 varchar(10) utf8_general_ci Yes NULL
72 varchar(10) utf8_general_ci Yes NULL
73 varchar(10) utf8_general_ci Yes NULL
74 varchar(10) utf8_general_ci Yes NULL
75 varchar(10) utf8_general_ci Yes NULL
76 varchar(10) utf8_general_ci Yes NULL
77 varchar(10) utf8_general_ci Yes NULL
78 varchar(10) utf8_general_ci Yes NULL
79 varchar(10) utf8_general_ci Yes NULL
80 varchar(10) utf8_general_ci Yes NULL
81 varchar(10) utf8_general_ci Yes NULL
82 varchar(10) utf8_general_ci Yes NULL
83 varchar(10) utf8_general_ci Yes NULL
84 varchar(10) utf8_general_ci Yes NULL
85 int(3) Yes NULL
86 varchar(100) utf8_general_ci Yes NULL
87 varchar(20) utf8_general_ci Yes NULL
88 varchar(20) utf8_general_ci Yes NULL
89 varchar(100) utf8_general_ci Yes NULL
90 varchar(10) utf8_general_ci Yes NULL
91 int(4) Yes NULL
92 int(2) Yes NULL
93 varchar(10) utf8_general_ci Yes NULL
94 varchar(5) utf8_general_ci Yes NULL
95 varchar(100) utf8_general_ci Yes NULL
96 int(4) Yes NULL

Move the columns by dragging them up and down.

    Add column  Add column(s)  
    IndexesDocumentation
    No index defined!
    Partitions Documentation
    No partitioning defined!
    Information
    Space usage
    Data 2.5 MiB
    Index 0 B
    Overhead
    Effective 2.5 MiB
    Total 2.5 MiB
    Row statistics
    Format Compact
    Collation latin1_swedish_ci
    Next autoindex 0
    Creation Feb 02, 2023 at 01:07 PM
    Last update Sep 24, 2024 at 04:24 AM
    Last check Sep 24, 2024 at 04:24 AM
    mysqli_real_connect(): (HY000/1045): Access denied for user 'pma'@'localhost' (using password: NO)
    Connection for controluser as defined in your configuration failed.