Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_module_tracker
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 730112 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
statid
int(11)
No
0
stattype
varchar(50)
utf8_general_ci
No
trackername
varchar(50)
utf8_general_ci
No
newsletterid
int(11)
Yes
NULL
datastring
text
utf8_general_ci
Yes
NULL
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
statid
stattype
trackername
newsletterid
datastring
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
4
statid
stattype
trackername
statid_2
UNIQUE
4
statid
statid_4
UNIQUE
4
statid
statid_5
UNIQUE
4
statid
statid_7
UNIQUE
4
statid
statid_10
UNIQUE
4
statid
statid_13
UNIQUE
4
statid
statid_14
UNIQUE
4
statid
statid_16
UNIQUE
4
statid
statid
INDEX
4
statid
stattype
INDEX
2
stattype
trackername
INDEX
2
trackername
newsletterid
INDEX
4
newsletterid
statid_3
INDEX
4
statid
newsletterid_2
INDEX
4
newsletterid
stattype_2
INDEX
2
stattype
trackername_2
INDEX
2
trackername
stattype_3
INDEX
2
stattype
statid_6
INDEX
4
statid
trackername_3
INDEX
2
trackername
newsletterid_3
INDEX
4
newsletterid
statid_8
INDEX
4
statid
stattype_4
INDEX
2
stattype
newsletterid_4
INDEX
4
newsletterid
trackername_4
INDEX
2
trackername
statid_9
INDEX
4
statid
stattype_5
INDEX
2
stattype
statid_11
INDEX
4
statid
newsletterid_5
INDEX
4
newsletterid
trackername_5
INDEX
2
trackername
newsletterid_6
INDEX
4
newsletterid
stattype_6
INDEX
2
stattype
trackername_6
INDEX
2
trackername
statid_12
INDEX
4
statid
stattype_7
INDEX
2
stattype
trackername_7
INDEX
2
trackername
newsletterid_7
INDEX
4
newsletterid
statid_15
INDEX
4
statid
newsletterid_8
INDEX
4
newsletterid
trackername_8
INDEX
2
trackername
stattype_8
INDEX
2
stattype
statid_17
INDEX
4
statid
Create an index on
columns
Space usage:
Type
Usage
Data
16,384
Bytes
Index
671,744
Bytes
Total
688,128
Bytes
Row Statistic:
Statements
Value
Format
dynamic
Collation
utf8_general_ci
Creation
Apr 25, 2024 at 05:28 PM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `email_module_tracker` WHERE 1
statid
stattype
trackername
newsletterid
datastring
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