Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_forms
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 743424 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
formid
int(11)
No
auto_increment
name
varchar(255)
utf8_general_ci
Yes
NULL
design
varchar(255)
utf8_general_ci
Yes
NULL
formhtml
longtext
utf8_general_ci
Yes
NULL
chooseformat
varchar(2)
utf8_general_ci
Yes
NULL
changeformat
char(1)
utf8_general_ci
Yes
0
sendthanks
char(1)
utf8_general_ci
Yes
0
requireconfirm
char(1)
utf8_general_ci
Yes
0
ownerid
int(11)
Yes
0
formtype
char(1)
utf8_general_ci
Yes
NULL
createdate
int(11)
Yes
0
contactform
char(1)
utf8_general_ci
Yes
0
usecaptcha
char(1)
utf8_general_ci
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
formid
name
design
formhtml
chooseformat
changeformat
sendthanks
requireconfirm
ownerid
formtype
createdate
contactform
usecaptcha
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
3
formid
formid_2
UNIQUE
3
formid
formid_3
UNIQUE
3
formid
formid_6
UNIQUE
3
formid
formid_7
UNIQUE
3
formid
name_2
UNIQUE
3
name
design_2
UNIQUE
3
design
createdate_2
UNIQUE
3
createdate
createdate_3
UNIQUE
3
createdate
name_3
UNIQUE
3
name
design_4
UNIQUE
3
design
name_6
UNIQUE
3
name
design_6
UNIQUE
3
design
name_7
UNIQUE
3
name
design_8
UNIQUE
3
design
createdate_6
UNIQUE
3
createdate
name_9
UNIQUE
3
name
design_9
UNIQUE
3
design
formid
INDEX
3
formid
name
INDEX
3
name
design
INDEX
3
design
chooseformat
INDEX
3
chooseformat
changeformat
INDEX
3
changeformat
sendthanks
INDEX
3
sendthanks
requireconfirm
INDEX
3
requireconfirm
ownerid
INDEX
3
ownerid
formtype
INDEX
3
formtype
createdate
INDEX
3
createdate
contactform
INDEX
3
contactform
usecaptcha
INDEX
3
usecaptcha
design_3
INDEX
3
design
usecaptcha_2
INDEX
3
usecaptcha
formtype_2
INDEX
3
formtype
createdate_4
INDEX
3
createdate
formid_4
INDEX
3
formid
requireconfirm_2
INDEX
3
requireconfirm
ownerid_2
INDEX
3
ownerid
chooseformat_2
INDEX
3
chooseformat
changeformat_2
INDEX
3
changeformat
sendthanks_2
INDEX
3
sendthanks
name_4
INDEX
3
name
contactform_2
INDEX
3
contactform
ownerid_3
INDEX
3
ownerid
formid_5
INDEX
3
formid
name_5
INDEX
3
name
design_5
INDEX
3
design
chooseformat_3
INDEX
3
chooseformat
changeformat_3
INDEX
3
changeformat
sendthanks_3
INDEX
3
sendthanks
requireconfirm_3
INDEX
3
requireconfirm
design_7
INDEX
3
design
formtype_3
INDEX
3
formtype
chooseformat_4
INDEX
3
chooseformat
requireconfirm_4
INDEX
3
requireconfirm
ownerid_4
INDEX
3
ownerid
createdate_5
INDEX
3
createdate
usecaptcha_3
INDEX
3
usecaptcha
formid_8
INDEX
3
formid
name_8
INDEX
3
name
contactform_3
INDEX
3
contactform
changeformat_4
INDEX
3
changeformat
sendthanks_4
INDEX
3
sendthanks
requireconfirm_5
INDEX
3
requireconfirm
formtype_4
INDEX
3
formtype
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
4
Creation
Mar 07, 2024 at 02:01 AM
Run SQL query/queries on database puroparty
Fields:
ALTER TABLE `email_forms` ADD UNIQUE(`contactform`)
formid
name
design
formhtml
chooseformat
changeformat
sendthanks
requireconfirm
ownerid
formtype
createdate
contactform
usecaptcha
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