Server:
mysql.puroparty.com
Database:
puroparty
Table:
bak_banner
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Field
Type
Collation
Attributes
Null
Default
Extra
Action
bid
int(11)
No
auto_increment
cid
int(11)
No
0
type
varchar(30)
utf8_general_ci
No
banner
name
varchar(255)
utf8_general_ci
No
alias
varchar(255)
utf8_general_ci
No
imptotal
int(11)
No
0
impmade
int(11)
No
0
clicks
int(11)
No
0
imageurl
varchar(100)
utf8_general_ci
No
clickurl
varchar(200)
utf8_general_ci
No
date
datetime
Yes
NULL
showBanner
tinyint(1)
No
0
checked_out
tinyint(1)
No
0
checked_out_time
datetime
No
0000-00-00 00:00:00
editor
varchar(50)
utf8_general_ci
Yes
NULL
custombannercode
text
utf8_general_ci
Yes
NULL
catid
int(10)
UNSIGNED
No
0
description
text
utf8_general_ci
No
sticky
tinyint(1)
UNSIGNED
No
0
ordering
int(11)
No
0
publish_up
datetime
No
0000-00-00 00:00:00
publish_down
datetime
No
0000-00-00 00:00:00
tags
text
utf8_general_ci
No
params
text
utf8_general_ci
No
Check All
/
Uncheck All
With selected:
Print view
Propose table structure
Add new field:
At End of Table
At Beginning of Table
After
bid
cid
type
name
alias
imptotal
impmade
clicks
imageurl
clickurl
date
showBanner
checked_out
checked_out_time
editor
custombannercode
catid
description
sticky
ordering
publish_up
publish_down
tags
params
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
0
bid
bid_2
UNIQUE
0
bid
cid_2
UNIQUE
0
cid
type_2
UNIQUE
0
type
name_2
UNIQUE
0
name
alias_2
UNIQUE
0
alias
imptotal_2
UNIQUE
0
imptotal
impmade_2
UNIQUE
0
impmade
clicks_2
UNIQUE
0
clicks
imageurl_2
UNIQUE
0
imageurl
clickurl_2
UNIQUE
0
clickurl
showBanner_2
UNIQUE
0
showBanner
checked_out_2
UNIQUE
0
checked_out
checked_out_time_2
UNIQUE
0
checked_out_time
catid_2
UNIQUE
0
catid
sticky_2
UNIQUE
0
sticky
ordering_2
UNIQUE
0
ordering
publish_up_2
UNIQUE
0
publish_up
publish_down_2
UNIQUE
0
publish_down
clicks_3
UNIQUE
0
clicks
cid_3
UNIQUE
0
cid
alias_4
UNIQUE
0
alias
imptotal_3
UNIQUE
0
imptotal
clickurl_5
UNIQUE
0
clickurl
date_2
UNIQUE
None
date
editor_2
UNIQUE
None
editor
viewbanner
INDEX
None
showBanner
idx_banner_catid
INDEX
None
catid
bid
INDEX
None
bid
cid
INDEX
None
cid
type
INDEX
None
type
name
INDEX
None
name
alias
INDEX
None
alias
imptotal
INDEX
None
imptotal
impmade
INDEX
None
impmade
clicks
INDEX
None
clicks
imageurl
INDEX
None
imageurl
clickurl
INDEX
None
clickurl
date
INDEX
None
date
showBanner
INDEX
None
showBanner
checked_out
INDEX
None
checked_out
checked_out_time
INDEX
None
checked_out_time
editor
INDEX
None
editor
catid
INDEX
None
catid
sticky
INDEX
None
sticky
ordering
INDEX
None
ordering
publish_up
INDEX
None
publish_up
publish_down
INDEX
None
publish_down
checked_out_time_3
INDEX
None
checked_out_time
catid_3
INDEX
None
catid
cid_4
INDEX
None
cid
type_3
FULLTEXT
None
type
name_3
FULLTEXT
None
name
alias_3
FULLTEXT
None
alias
imageurl_3
FULLTEXT
None
imageurl
clickurl_3
FULLTEXT
None
clickurl
editor_3
FULLTEXT
None
editor
custombannercode
FULLTEXT
None
custombannercode
description
FULLTEXT
None
description
tags
FULLTEXT
None
tags
params
FULLTEXT
None
params
clickurl_4
FULLTEXT
None
clickurl
params_2
FULLTEXT
None
params
name_4
FULLTEXT
None
name
Create an index on
columns
Space usage:
Type
Usage
Data
0
Bytes
Index
4,096
Bytes
Total
4,096
Bytes
Row Statistic:
Statements
Value
Format
dynamic
Collation
utf8_general_ci
Rows
0
Next Autoindex
1
Creation
Oct 18, 2017 at 02:20 PM
Last update
May 19, 2024 at 05:52 AM
Last check
May 19, 2024 at 01:27 PM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `bak_banner` WHERE 1
bid
cid
type
name
alias
imptotal
impmade
clicks
imageurl
clickurl
date
showBanner
checked_out
checked_out_time
editor
custombannercode
catid
description
sticky
ordering
publish_up
publish_down
tags
params
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