Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_form_customfields
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 729088 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
formid
int(11)
Yes
0
fieldid
varchar(10)
utf8_general_ci
Yes
0
fieldorder
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
formid
fieldid
fieldorder
Indexes:
Keyname
Type
Cardinality
Action
Field
email_form_customfields_formid_listid_idx
UNIQUE
13
formid
fieldid
formid
INDEX
6
formid
fieldid
INDEX
13
fieldid
fieldorder
INDEX
13
fieldorder
fieldid_2
INDEX
13
fieldid
fieldorder_2
INDEX
13
fieldorder
formid_2
INDEX
6
formid
formid_3
INDEX
6
formid
fieldorder_3
INDEX
13
fieldorder
fieldid_3
INDEX
13
fieldid
formid_4
INDEX
6
formid
fieldorder_4
INDEX
13
fieldorder
fieldorder_5
INDEX
13
fieldorder
fieldid_4
INDEX
13
fieldid
formid_5
INDEX
6
formid
formid_6
INDEX
6
formid
formid_7
INDEX
6
formid
fieldid_5
INDEX
13
fieldid
fieldorder_6
INDEX
13
fieldorder
fieldorder_7
INDEX
13
fieldorder
fieldid_6
INDEX
13
fieldid
formid_8
INDEX
6
formid
fieldid_7
INDEX
13
fieldid
fieldorder_8
INDEX
13
fieldorder
fieldid_8
INDEX
13
fieldid
formid_9
INDEX
6
formid
fieldid_9
INDEX
13
fieldid
fieldorder_9
INDEX
13
fieldorder
fieldid_10
INDEX
13
fieldid
fieldorder_10
INDEX
13
fieldorder
formid_10
INDEX
6
formid
fieldorder_11
INDEX
13
fieldorder
formid_11
INDEX
6
formid
fieldid_11
INDEX
13
fieldid
formid_12
INDEX
6
formid
fieldorder_12
INDEX
13
fieldorder
fieldid_12
INDEX
13
fieldid
fieldid_13
INDEX
13
fieldid
fieldorder_13
INDEX
13
fieldorder
fieldorder_14
INDEX
13
fieldorder
fieldid_14
INDEX
13
fieldid
fieldid_15
INDEX
13
fieldid
formid_13
INDEX
6
formid
fieldid_16
INDEX
13
fieldid
formid_14
INDEX
6
formid
formid_15
INDEX
6
formid
formid_16
INDEX
6
formid
formid_17
INDEX
6
formid
fieldid_17
INDEX
13
fieldid
fieldid_18
INDEX
13
fieldid
fieldorder_15
INDEX
13
fieldorder
formid_18
INDEX
6
formid
fieldorder_16
INDEX
13
fieldorder
formid_19
INDEX
6
formid
fieldid_19
INDEX
13
fieldid
fieldid_20
INDEX
13
fieldid
fieldid_21
INDEX
13
fieldid
fieldid_22
INDEX
13
fieldid
fieldorder_17
INDEX
13
fieldorder
Create an index on
columns
Space usage:
Type
Usage
Data
16,384
Bytes
Index
966,656
Bytes
Total
983,040
Bytes
Row Statistic:
Statements
Value
Format
dynamic
Collation
utf8_general_ci
Creation
Jun 16, 2024 at 12:22 PM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `email_form_customfields` WHERE 1
formid
fieldid
fieldorder
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