Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_form_lists
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 729088 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
formid
int(11)
No
0
listid
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
listid
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
2
formid
formid_2
UNIQUE
2
formid
formid_4
UNIQUE
2
formid
formid_6
UNIQUE
2
formid
formid_9
UNIQUE
2
formid
formid_10
UNIQUE
2
formid
formid_12
UNIQUE
2
formid
formid_14
UNIQUE
2
formid
formid_16
UNIQUE
2
formid
formid_18
UNIQUE
2
formid
formid_20
UNIQUE
2
formid
formid_21
UNIQUE
2
formid
formid_23
UNIQUE
2
formid
formid_24
UNIQUE
2
formid
formid_25
UNIQUE
2
formid
email_form_lists_formid_listid_idx
UNIQUE
2
formid
listid
listid_2
UNIQUE
2
listid
listid_3
UNIQUE
2
listid
listid_5
UNIQUE
2
listid
listid_7
UNIQUE
2
listid
listid_9
UNIQUE
2
listid
listid_11
UNIQUE
2
listid
listid_13
UNIQUE
2
listid
listid_15
UNIQUE
2
listid
listid_18
UNIQUE
2
listid
listid_20
UNIQUE
2
listid
listid_22
UNIQUE
2
listid
listid_23
UNIQUE
2
listid
listid_24
UNIQUE
2
listid
listid_25
UNIQUE
2
listid
listid_26
UNIQUE
2
listid
listid_27
UNIQUE
2
listid
listid_28
UNIQUE
2
listid
listid_29
UNIQUE
2
listid
listid_30
UNIQUE
2
listid
listid_31
UNIQUE
2
listid
formid
INDEX
2
formid
listid
INDEX
2
listid
formid_3
INDEX
2
formid
listid_4
INDEX
2
listid
formid_5
INDEX
2
formid
listid_6
INDEX
2
listid
formid_7
INDEX
2
formid
formid_8
INDEX
2
formid
listid_8
INDEX
2
listid
formid_11
INDEX
2
formid
listid_10
INDEX
2
listid
listid_12
INDEX
2
listid
formid_13
INDEX
2
formid
formid_15
INDEX
2
formid
listid_14
INDEX
2
listid
listid_16
INDEX
2
listid
formid_17
INDEX
2
formid
listid_17
INDEX
2
listid
formid_19
INDEX
2
formid
listid_19
INDEX
2
listid
listid_21
INDEX
2
listid
formid_22
INDEX
2
formid
formid_26
INDEX
2
formid
formid_27
INDEX
2
formid
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
fixed
Collation
utf8_general_ci
Creation
Jun 08, 2024 at 07:33 PM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `email_form_lists` WHERE 1
formid
listid
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