Server:
mysql.puroparty.com
Database:
puroparty
Table:
photopost_ecards
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Field
Type
Collation
Attributes
Null
Default
Extra
Action
id
int(25)
No
auto_increment
fromname
varchar(100)
latin1_swedish_ci
No
toname
varchar(100)
latin1_swedish_ci
No
subject
varchar(150)
latin1_swedish_ci
No
message
text
latin1_swedish_ci
No
photoid
int(25)
No
0
date
int(25)
No
0
backcolor
varchar(12)
latin1_swedish_ci
No
#696969
bordcolor
varchar(12)
latin1_swedish_ci
No
#000000
fontcolor
varchar(12)
latin1_swedish_ci
No
#FFFFFF
pickfont
varchar(32)
latin1_swedish_ci
No
arial
layout
varchar(24)
latin1_swedish_ci
No
tobottom
returnr
int(15)
No
0
readdate
int(15)
No
0
Check All
/
Uncheck All
With selected:
Print view
Propose table structure
Add new field:
At End of Table
At Beginning of Table
After
id
fromname
toname
subject
message
photoid
date
backcolor
bordcolor
fontcolor
pickfont
layout
returnr
readdate
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
0
id
id_2
UNIQUE
0
id
fromname_2
UNIQUE
0
fromname
toname_2
UNIQUE
0
toname
subject_2
UNIQUE
0
subject
photoid_2
UNIQUE
0
photoid
date_2
UNIQUE
0
date
backcolor_2
UNIQUE
0
backcolor
bordcolor_2
UNIQUE
0
bordcolor
fontcolor_2
UNIQUE
0
fontcolor
pickfont_2
UNIQUE
0
pickfont
layout_2
UNIQUE
0
layout
returnr_2
UNIQUE
0
returnr
readdate_2
UNIQUE
0
readdate
photoid_3
UNIQUE
0
photoid
readdate_4
UNIQUE
0
readdate
pickfont_5
UNIQUE
0
pickfont
layout_6
UNIQUE
0
layout
fromname_5
UNIQUE
0
fromname
backcolor_6
UNIQUE
0
backcolor
id_4
UNIQUE
0
id
date_4
UNIQUE
0
date
toname_5
UNIQUE
0
toname
id
INDEX
None
id
fromname
INDEX
None
fromname
toname
INDEX
None
toname
subject
INDEX
None
subject
photoid
INDEX
None
photoid
date
INDEX
None
date
backcolor
INDEX
None
backcolor
bordcolor
INDEX
None
bordcolor
fontcolor
INDEX
None
fontcolor
pickfont
INDEX
None
pickfont
layout
INDEX
None
layout
returnr
INDEX
None
returnr
readdate
INDEX
None
readdate
returnr_3
INDEX
None
returnr
id_3
INDEX
None
id
fromname_4
INDEX
None
fromname
readdate_3
INDEX
None
readdate
date_3
INDEX
None
date
fontcolor_4
INDEX
None
fontcolor
layout_5
INDEX
None
layout
backcolor_4
INDEX
None
backcolor
toname_4
INDEX
None
toname
photoid_4
INDEX
None
photoid
subject_5
INDEX
None
subject
bordcolor_5
INDEX
None
bordcolor
fromname_3
FULLTEXT
None
fromname
toname_3
FULLTEXT
None
toname
subject_3
FULLTEXT
None
subject
message
FULLTEXT
None
message
backcolor_3
FULLTEXT
None
backcolor
bordcolor_3
FULLTEXT
None
bordcolor
fontcolor_3
FULLTEXT
None
fontcolor
pickfont_3
FULLTEXT
None
pickfont
layout_3
FULLTEXT
None
layout
pickfont_4
FULLTEXT
None
pickfont
layout_4
FULLTEXT
None
layout
subject_4
FULLTEXT
None
subject
fontcolor_5
FULLTEXT
None
fontcolor
bordcolor_4
FULLTEXT
None
bordcolor
backcolor_5
FULLTEXT
None
backcolor
message_2
FULLTEXT
None
message
Create an index on
columns
Space usage:
Type
Usage
Data
0
Bytes
Index
3,072
Bytes
Total
3,072
Bytes
Row Statistic:
Statements
Value
Format
dynamic
Collation
latin1_swedish_ci
Rows
0
Next Autoindex
1
Creation
Oct 23, 2017 at 04:03 AM
Last update
Oct 23, 2017 at 04:03 AM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `photopost_ecards` WHERE 1
id
fromname
toname
subject
message
photoid
date
backcolor
bordcolor
fontcolor
pickfont
layout
returnr
readdate
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