Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_autoresponders
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 722944 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
autoresponderid
int(11)
No
auto_increment
name
varchar(255)
utf8_general_ci
Yes
NULL
subject
varchar(255)
utf8_general_ci
Yes
NULL
format
char(1)
utf8_general_ci
Yes
NULL
textbody
longtext
utf8_general_ci
Yes
NULL
htmlbody
longtext
utf8_general_ci
Yes
NULL
createdate
int(11)
Yes
0
active
int(11)
Yes
0
hoursaftersubscription
int(11)
Yes
0
ownerid
int(11)
No
0
searchcriteria
mediumtext
utf8_general_ci
Yes
NULL
listid
int(11)
Yes
0
tracklinks
char(1)
utf8_general_ci
Yes
1
trackopens
char(1)
utf8_general_ci
Yes
1
multipart
char(1)
utf8_general_ci
Yes
1
queueid
int(11)
Yes
0
sendfromname
varchar(255)
utf8_general_ci
Yes
NULL
sendfromemail
varchar(255)
utf8_general_ci
Yes
NULL
replytoemail
varchar(255)
utf8_general_ci
Yes
NULL
bounceemail
varchar(255)
utf8_general_ci
Yes
NULL
charset
varchar(255)
utf8_general_ci
Yes
NULL
embedimages
char(1)
utf8_general_ci
Yes
0
to_firstname
int(11)
Yes
0
to_lastname
int(11)
Yes
0
autorespondersize
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
autoresponderid
name
subject
format
textbody
htmlbody
createdate
active
hoursaftersubscription
ownerid
searchcriteria
listid
tracklinks
trackopens
multipart
queueid
sendfromname
sendfromemail
replytoemail
bounceemail
charset
embedimages
to_firstname
to_lastname
autorespondersize
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
0
autoresponderid
autoresponderid_2
UNIQUE
0
autoresponderid
ownerid_2
UNIQUE
0
ownerid
autoresponderid_3
UNIQUE
0
autoresponderid
name_2
UNIQUE
0
name
subject_2
UNIQUE
0
subject
format_2
UNIQUE
0
format
createdate_2
UNIQUE
0
createdate
active_2
UNIQUE
0
active
hoursaftersubscription_2
UNIQUE
0
hoursaftersubscription
listid_2
UNIQUE
0
listid
tracklinks_2
UNIQUE
0
tracklinks
trackopens_2
UNIQUE
0
trackopens
multipart_2
UNIQUE
0
multipart
queueid_2
UNIQUE
0
queueid
sendfromname_2
UNIQUE
0
sendfromname
sendfromemail_2
UNIQUE
0
sendfromemail
replytoemail_2
UNIQUE
0
replytoemail
bounceemail_2
UNIQUE
0
bounceemail
charset_2
UNIQUE
0
charset
embedimages_2
UNIQUE
0
embedimages
to_firstname_2
UNIQUE
0
to_firstname
to_lastname_2
UNIQUE
0
to_lastname
autorespondersize_2
UNIQUE
0
autorespondersize
bounceemail_3
UNIQUE
0
bounceemail
format_3
UNIQUE
0
format
multipart_3
UNIQUE
0
multipart
trackopens_3
UNIQUE
0
trackopens
name_4
UNIQUE
0
name
createdate_3
UNIQUE
0
createdate
email_autoresponders_owner_idx
INDEX
0
ownerid
email_autoresponders_list_idx
INDEX
0
listid
email_autoresponders_queue_idx
INDEX
0
queueid
autoresponderid
INDEX
0
autoresponderid
name
INDEX
0
name
subject
INDEX
0
subject
format
INDEX
0
format
createdate
INDEX
0
createdate
active
INDEX
0
active
hoursaftersubscription
INDEX
0
hoursaftersubscription
ownerid
INDEX
0
ownerid
listid
INDEX
0
listid
tracklinks
INDEX
0
tracklinks
trackopens
INDEX
0
trackopens
multipart
INDEX
0
multipart
queueid
INDEX
0
queueid
sendfromname
INDEX
0
sendfromname
sendfromemail
INDEX
0
sendfromemail
replytoemail
INDEX
0
replytoemail
bounceemail
INDEX
0
bounceemail
charset
INDEX
0
charset
embedimages
INDEX
0
embedimages
to_firstname
INDEX
0
to_firstname
to_lastname
INDEX
0
to_lastname
autorespondersize
INDEX
0
autorespondersize
name_3
INDEX
0
name
autorespondersize_3
INDEX
0
autorespondersize
sendfromemail_3
INDEX
0
sendfromemail
active_3
INDEX
0
active
tracklinks_3
INDEX
0
tracklinks
to_lastname_3
INDEX
0
to_lastname
queueid_3
INDEX
0
queueid
ownerid_3
INDEX
0
ownerid
subject_3
INDEX
0
subject
Create an index on
columns
Space usage:
Type
Usage
Data
16,384
Bytes
Index
1,008
KB
Total
1,024
KB
Row Statistic:
Statements
Value
Format
dynamic
Collation
utf8_general_ci
Next Autoindex
1
Creation
May 14, 2024 at 02:59 AM
Run SQL query/queries on database puroparty
Fields:
ALTER TABLE `email_autoresponders` ADD UNIQUE(`replytoemail`)
autoresponderid
name
subject
format
textbody
htmlbody
createdate
active
hoursaftersubscription
ownerid
searchcriteria
listid
tracklinks
trackopens
multipart
queueid
sendfromname
sendfromemail
replytoemail
bounceemail
charset
embedimages
to_firstname
to_lastname
autorespondersize
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