Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_stats_linkclicks
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 737280 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
clickid
int(11)
No
auto_increment
clicktime
int(11)
Yes
0
clickip
varchar(20)
utf8_general_ci
Yes
NULL
subscriberid
int(11)
Yes
0
statid
int(11)
Yes
0
linkid
int(11)
Yes
0
Check All
/
Uncheck All
With selected:
Print view
Relation view
Propose table structure
Add new field:
At End of Table
At Beginning of Table
After
clickid
clicktime
clickip
subscriberid
statid
linkid
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
3758
clickid
clickid_2
UNIQUE
3758
clickid
clickid_4
UNIQUE
3758
clickid
clickid_5
UNIQUE
3758
clickid
clickid_7
UNIQUE
3758
clickid
clickid_9
UNIQUE
3758
clickid
clickid_12
UNIQUE
3758
clickid
clickid_13
UNIQUE
3758
clickid
clickid_15
UNIQUE
3758
clickid
email_stats_linkclicks_subscriberid_idx
INDEX
3758
subscriberid
email_stats_linkclicks_statid_idx
INDEX
75
statid
email_stats_linkclicks_linkid_idx
INDEX
68
linkid
email_stats_linkclicks_subscriberid
INDEX
3758
subscriberid
clickid
INDEX
3758
clickid
clicktime
INDEX
3758
clicktime
clickip
INDEX
3758
clickip
subscriberid
INDEX
3758
subscriberid
statid
INDEX
75
statid
linkid
INDEX
67
linkid
clickip_2
INDEX
3758
clickip
clickid_3
INDEX
3758
clickid
statid_2
INDEX
83
statid
clicktime_2
INDEX
3758
clicktime
subscriberid_2
INDEX
3758
subscriberid
linkid_2
INDEX
67
linkid
clickip_3
INDEX
3758
clickip
linkid_3
INDEX
68
linkid
statid_3
INDEX
113
statid
subscriberid_3
INDEX
3758
subscriberid
clicktime_3
INDEX
3758
clicktime
clickid_6
INDEX
3758
clickid
linkid_4
INDEX
67
linkid
clickip_4
INDEX
3758
clickip
clicktime_4
INDEX
3758
clicktime
subscriberid_4
INDEX
3758
subscriberid
clickid_8
INDEX
3758
clickid
linkid_5
INDEX
67
linkid
clickip_5
INDEX
3758
clickip
statid_4
INDEX
75
statid
subscriberid_5
INDEX
3758
subscriberid
clicktime_5
INDEX
3758
clicktime
statid_5
INDEX
113
statid
clickid_10
INDEX
3758
clickid
linkid_6
INDEX
67
linkid
clickid_11
INDEX
3758
clickid
clicktime_6
INDEX
3758
clicktime
clickip_6
INDEX
3758
clickip
subscriberid_6
INDEX
3758
subscriberid
statid_6
INDEX
113
statid
linkid_7
INDEX
67
linkid
linkid_8
INDEX
68
linkid
statid_7
INDEX
78
statid
subscriberid_7
INDEX
3758
subscriberid
clicktime_7
INDEX
3758
clicktime
linkid_9
INDEX
67
linkid
clickip_7
INDEX
3758
clickip
clickid_14
INDEX
3758
clickid
statid_8
INDEX
72
statid
subscriberid_8
INDEX
3758
subscriberid
clicktime_8
INDEX
3758
clicktime
linkid_10
INDEX
67
linkid
clickid_16
INDEX
3758
clickid
clickip_8
INDEX
3758
clickip
clickid_17
INDEX
3758
clickid
Create an index on
columns
Space usage:
Type
Usage
Data
294,912
Bytes
Index
7,152
KB
Total
7,440
KB
Row Statistic:
Statements
Value
Format
dynamic
Collation
utf8_general_ci
Next Autoindex
3,939
Creation
Mar 28, 2024 at 02:21 PM
Run SQL query/queries on database puroparty
Fields:
ALTER TABLE `email_stats_linkclicks` ADD UNIQUE(`statid`)
clickid
clicktime
clickip
subscriberid
statid
linkid
Show this query here again
Or
Location of the textfile:
Location of the textfile:
(Max: 2,048KB)
Compression:
Autodetect
None
"gzipped"
"bzipped"
Character set of the file:
armscii8
ascii
big5
binary
cp1250
cp1251
cp1256
cp1257
cp850
cp852
cp866
cp932
dec8
euckr
gb2312
gbk
geostd8
greek
hebrew
hp8
keybcs2
koi8r
koi8u
latin1
latin2
latin5
latin7
macce
macroman
sjis
swe7
tis620
ucs2
ujis
utf8
Insert data from a textfile into table