Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_form_pages
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 729088 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
pageid
int(11)
No
auto_increment
formid
int(11)
Yes
0
pagetype
varchar(100)
utf8_general_ci
Yes
NULL
html
longtext
utf8_general_ci
Yes
NULL
url
varchar(255)
utf8_general_ci
Yes
NULL
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
emailsubject
varchar(255)
utf8_general_ci
Yes
NULL
emailhtml
longtext
utf8_general_ci
Yes
NULL
emailtext
longtext
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
pageid
formid
pagetype
html
url
sendfromname
sendfromemail
replytoemail
bounceemail
emailsubject
emailhtml
emailtext
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
9
pageid
pageid_2
UNIQUE
9
pageid
pageid_3
UNIQUE
9
pageid
pageid_6
UNIQUE
9
pageid
pageid_7
UNIQUE
9
pageid
pageid_10
UNIQUE
9
pageid
pageid_11
UNIQUE
9
pageid
pageid_14
UNIQUE
9
pageid
email_form_pages_formid_idx
INDEX
9
formid
pageid
INDEX
9
pageid
formid
INDEX
9
formid
pagetype
INDEX
9
pagetype
url
INDEX
4
url
sendfromname
INDEX
9
sendfromname
sendfromemail
INDEX
9
sendfromemail
replytoemail
INDEX
9
replytoemail
bounceemail
INDEX
9
bounceemail
emailsubject
INDEX
9
emailsubject
emailsubject_2
INDEX
9
emailsubject
pagetype_2
INDEX
9
pagetype
sendfromemail_2
INDEX
9
sendfromemail
url_2
INDEX
4
url
replytoemail_2
INDEX
9
replytoemail
formid_2
INDEX
9
formid
bounceemail_2
INDEX
9
bounceemail
sendfromname_2
INDEX
9
sendfromname
pageid_4
INDEX
9
pageid
url_3
INDEX
4
url
bounceemail_3
INDEX
9
bounceemail
sendfromname_3
INDEX
9
sendfromname
replytoemail_3
INDEX
9
replytoemail
sendfromemail_3
INDEX
9
sendfromemail
pageid_5
INDEX
9
pageid
formid_3
INDEX
9
formid
pagetype_3
INDEX
9
pagetype
emailsubject_3
INDEX
9
emailsubject
replytoemail_4
INDEX
9
replytoemail
pagetype_4
INDEX
9
pagetype
sendfromemail_4
INDEX
9
sendfromemail
emailsubject_4
INDEX
9
emailsubject
formid_4
INDEX
9
formid
url_4
INDEX
4
url
pageid_8
INDEX
9
pageid
sendfromname_4
INDEX
9
sendfromname
bounceemail_4
INDEX
9
bounceemail
replytoemail_5
INDEX
9
replytoemail
pagetype_5
INDEX
9
pagetype
formid_5
INDEX
9
formid
pageid_9
INDEX
9
pageid
bounceemail_5
INDEX
9
bounceemail
emailsubject_5
INDEX
9
emailsubject
replytoemail_6
INDEX
9
replytoemail
sendfromname_5
INDEX
9
sendfromname
url_5
INDEX
4
url
sendfromemail_5
INDEX
9
sendfromemail
emailsubject_6
INDEX
9
emailsubject
pagetype_6
INDEX
9
pagetype
sendfromemail_6
INDEX
9
sendfromemail
url_6
INDEX
4
url
formid_6
INDEX
9
formid
pageid_12
INDEX
9
pageid
sendfromemail_7
INDEX
9
sendfromemail
pagetype_7
INDEX
9
pagetype
pageid_13
INDEX
9
pageid
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
25
Creation
Jun 08, 2024 at 05:50 PM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `email_form_pages` WHERE 1
pageid
formid
pagetype
html
url
sendfromname
sendfromemail
replytoemail
bounceemail
emailsubject
emailhtml
emailtext
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