Server:
mysql.puroparty.com
Database:
puroparty
Table:
email_newsletters
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
InnoDB free: 729088 kB
Field
Type
Collation
Attributes
Null
Default
Extra
Action
newsletterid
int(11)
No
auto_increment
name
varchar(255)
utf8_general_ci
Yes
NULL
format
char(1)
utf8_general_ci
Yes
NULL
subject
varchar(255)
utf8_general_ci
Yes
NULL
textbody
longtext
utf8_general_ci
Yes
NULL
htmlbody
longtext
utf8_general_ci
Yes
NULL
createdate
int(11)
Yes
0
active
int(11)
Yes
0
archive
int(11)
Yes
0
ownerid
int(11)
No
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
newsletterid
name
format
subject
textbody
htmlbody
createdate
active
archive
ownerid
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
23
newsletterid
newsletterid_2
UNIQUE
23
newsletterid
newsletterid_3
UNIQUE
23
newsletterid
newsletterid_6
UNIQUE
23
newsletterid
newsletterid_7
UNIQUE
23
newsletterid
newsletterid_10
UNIQUE
23
newsletterid
newsletterid_12
UNIQUE
23
newsletterid
newsletterid_14
UNIQUE
23
newsletterid
name_2
UNIQUE
23
name
name_3
UNIQUE
23
name
name_6
UNIQUE
23
name
name_7
UNIQUE
23
name
name_10
UNIQUE
23
name
email_newsletters_owner_idx
INDEX
2
ownerid
newsletterid
INDEX
23
newsletterid
name
INDEX
23
name
format
INDEX
2
format
subject
INDEX
23
subject
createdate
INDEX
23
createdate
active
INDEX
4
active
archive
INDEX
2
archive
ownerid
INDEX
2
ownerid
subject_2
INDEX
23
subject
ownerid_2
INDEX
2
ownerid
newsletterid_4
INDEX
23
newsletterid
createdate_2
INDEX
23
createdate
name_4
INDEX
23
name
active_2
INDEX
4
active
archive_2
INDEX
2
archive
format_2
INDEX
2
format
name_5
INDEX
23
name
subject_3
INDEX
23
subject
format_3
INDEX
2
format
ownerid_3
INDEX
2
ownerid
newsletterid_5
INDEX
23
newsletterid
active_3
INDEX
4
active
createdate_3
INDEX
23
createdate
archive_3
INDEX
2
archive
ownerid_4
INDEX
2
ownerid
subject_4
INDEX
23
subject
archive_4
INDEX
2
archive
createdate_4
INDEX
23
createdate
active_4
INDEX
4
active
newsletterid_8
INDEX
23
newsletterid
name_8
INDEX
23
name
format_4
INDEX
2
format
archive_5
INDEX
2
archive
archive_6
INDEX
2
archive
subject_5
INDEX
23
subject
ownerid_5
INDEX
2
ownerid
createdate_5
INDEX
23
createdate
newsletterid_9
INDEX
23
newsletterid
name_9
INDEX
23
name
active_5
INDEX
4
active
subject_6
INDEX
23
subject
ownerid_6
INDEX
2
ownerid
format_5
INDEX
2
format
createdate_6
INDEX
23
createdate
active_6
INDEX
4
active
name_11
INDEX
23
name
newsletterid_11
INDEX
23
newsletterid
ownerid_7
INDEX
2
ownerid
subject_7
INDEX
23
subject
newsletterid_13
INDEX
23
newsletterid
Create an index on
columns
Space usage:
Type
Usage
Data
147,456
Bytes
Index
1,008
KB
Total
1,152
KB
Row Statistic:
Statements
Value
Format
dynamic
Collation
utf8_general_ci
Next Autoindex
31
Creation
May 21, 2024 at 11:08 PM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `email_newsletters` WHERE 1
newsletterid
name
format
subject
textbody
htmlbody
createdate
active
archive
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