Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_customfields
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 729088 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
fieldid
int(11)
No
auto_increment
name
varchar(255)
utf8_general_ci
Yes
NULL
fieldtype
varchar(100)
utf8_general_ci
Yes
NULL
defaultvalue
varchar(255)
utf8_general_ci
Yes
NULL
required
char(1)
utf8_general_ci
Yes
0
fieldsettings
mediumtext
utf8_general_ci
Yes
NULL
createdate
int(11)
Yes
0
ownerid
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
fieldid
name
fieldtype
defaultvalue
required
fieldsettings
createdate
ownerid
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
9
fieldid
fieldid_2
UNIQUE
9
fieldid
fieldid_4
UNIQUE
9
fieldid
fieldid_6
UNIQUE
9
fieldid
fieldid_7
UNIQUE
9
fieldid
fieldid_9
UNIQUE
9
fieldid
fieldid_12
UNIQUE
9
fieldid
name_2
UNIQUE
9
name
createdate_2
UNIQUE
9
createdate
name_3
UNIQUE
9
name
createdate_4
UNIQUE
9
createdate
createdate_5
UNIQUE
9
createdate
name_6
UNIQUE
9
name
createdate_7
UNIQUE
9
createdate
name_7
UNIQUE
9
name
createdate_9
UNIQUE
9
createdate
name_10
UNIQUE
9
name
createdate_11
UNIQUE
9
createdate
createdate_12
UNIQUE
9
createdate
email_customfields_owner_idx
INDEX
2
ownerid
email_customfield_id_name
INDEX
9
fieldid
name
fieldid
INDEX
9
fieldid
name
INDEX
9
name
fieldtype
INDEX
9
fieldtype
defaultvalue
INDEX
4
defaultvalue
required
INDEX
2
required
createdate
INDEX
9
createdate
ownerid
INDEX
2
ownerid
fieldid_3
INDEX
9
fieldid
createdate_3
INDEX
9
createdate
ownerid_2
INDEX
2
ownerid
defaultvalue_2
INDEX
4
defaultvalue
required_2
INDEX
2
required
fieldtype_2
INDEX
9
fieldtype
name_4
INDEX
9
name
fieldid_5
INDEX
9
fieldid
name_5
INDEX
9
name
fieldtype_3
INDEX
9
fieldtype
defaultvalue_3
INDEX
4
defaultvalue
required_3
INDEX
2
required
createdate_6
INDEX
9
createdate
ownerid_3
INDEX
2
ownerid
required_4
INDEX
2
required
ownerid_4
INDEX
2
ownerid
defaultvalue_4
INDEX
4
defaultvalue
createdate_8
INDEX
9
createdate
fieldtype_4
INDEX
9
fieldtype
name_8
INDEX
9
name
fieldid_8
INDEX
9
fieldid
ownerid_5
INDEX
2
ownerid
name_9
INDEX
9
name
required_5
INDEX
2
required
required_6
INDEX
2
required
createdate_10
INDEX
9
createdate
ownerid_6
INDEX
2
ownerid
defaultvalue_5
INDEX
4
defaultvalue
fieldtype_5
INDEX
9
fieldtype
fieldtype_6
INDEX
9
fieldtype
defaultvalue_6
INDEX
4
defaultvalue
name_11
INDEX
9
name
createdate_13
INDEX
9
createdate
fieldid_10
INDEX
9
fieldid
fieldid_11
INDEX
9
fieldid
name_12
INDEX
9
name
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
11
Creation
Jun 09, 2024 at 07:18 PM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `email_customfields` WHERE 1
fieldid
name
fieldtype
defaultvalue
required
fieldsettings
createdate
ownerid
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