Server:
mysql.puroparty.com
Database:
puroparty
Table:
bak_bannerclient
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Field
Type
Collation
Attributes
Null
Default
Extra
Action
cid
int(11)
No
auto_increment
name
varchar(255)
utf8_general_ci
No
contact
varchar(255)
utf8_general_ci
No
email
varchar(255)
utf8_general_ci
No
extrainfo
text
utf8_general_ci
No
checked_out
tinyint(1)
No
0
checked_out_time
time
Yes
NULL
editor
varchar(50)
utf8_general_ci
Yes
NULL
Check All
/
Uncheck All
With selected:
Print view
Propose table structure
Add new field:
At End of Table
At Beginning of Table
After
cid
name
contact
email
extrainfo
checked_out
checked_out_time
editor
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
0
cid
cid_2
UNIQUE
0
cid
name_2
UNIQUE
0
name
contact_2
UNIQUE
0
contact
email_2
UNIQUE
0
email
checked_out_2
UNIQUE
0
checked_out
contact_4
UNIQUE
0
contact
cid_3
UNIQUE
0
cid
email_6
UNIQUE
0
email
checked_out_4
UNIQUE
0
checked_out
name_6
UNIQUE
0
name
name_7
UNIQUE
0
name
contact_9
UNIQUE
0
contact
email_9
UNIQUE
0
email
cid_6
UNIQUE
0
cid
checked_out_6
UNIQUE
0
checked_out
cid_8
UNIQUE
0
cid
name_11
UNIQUE
0
name
checked_out_time_2
UNIQUE
None
checked_out_time
editor_2
UNIQUE
None
editor
editor_4
UNIQUE
None
editor
checked_out_time_4
UNIQUE
None
checked_out_time
editor_7
UNIQUE
None
editor
checked_out_time_6
UNIQUE
None
checked_out_time
cid
INDEX
None
cid
name
INDEX
None
name
contact
INDEX
None
contact
email
INDEX
None
email
checked_out
INDEX
None
checked_out
checked_out_time
INDEX
None
checked_out_time
editor
INDEX
None
editor
checked_out_3
INDEX
None
checked_out
email_4
INDEX
None
email
name_4
INDEX
None
name
checked_out_time_3
INDEX
None
checked_out_time
editor_5
INDEX
None
editor
cid_4
INDEX
None
cid
contact_6
INDEX
None
contact
checked_out_time_5
INDEX
None
checked_out_time
email_8
INDEX
None
email
contact_8
INDEX
None
contact
checked_out_5
INDEX
None
checked_out
name_8
INDEX
None
name
cid_5
INDEX
None
cid
editor_9
INDEX
None
editor
cid_7
INDEX
None
cid
name_10
INDEX
None
name
contact_10
INDEX
None
contact
name_3
FULLTEXT
None
name
contact_3
FULLTEXT
None
contact
email_3
FULLTEXT
None
email
extrainfo
FULLTEXT
None
extrainfo
editor_3
FULLTEXT
None
editor
email_5
FULLTEXT
None
email
name_5
FULLTEXT
None
name
contact_5
FULLTEXT
None
contact
extrainfo_2
FULLTEXT
None
extrainfo
editor_6
FULLTEXT
None
editor
contact_7
FULLTEXT
None
contact
extrainfo_3
FULLTEXT
None
extrainfo
editor_8
FULLTEXT
None
editor
email_7
FULLTEXT
None
email
name_9
FULLTEXT
None
name
name_12
FULLTEXT
None
name
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
utf8_general_ci
Rows
0
Next Autoindex
1
Creation
Nov 21, 2017 at 10:44 PM
Last update
Apr 24, 2024 at 03:04 AM
Last check
Apr 24, 2024 at 03:04 AM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `bak_bannerclient` WHERE 1
cid
name
contact
email
extrainfo
checked_out
checked_out_time
editor
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