Server:
mysql.puroparty.com
Database:
puroparty
Table:
bak_users
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Field
Type
Collation
Attributes
Null
Default
Extra
Action
id
int(11)
No
auto_increment
name
varchar(255)
utf8_general_ci
No
username
varchar(150)
utf8_general_ci
No
email
varchar(100)
utf8_general_ci
No
password
varchar(100)
utf8_general_ci
No
usertype
varchar(25)
utf8_general_ci
No
block
tinyint(4)
No
0
sendEmail
tinyint(4)
Yes
0
gid
tinyint(3)
UNSIGNED
No
1
registerDate
datetime
No
0000-00-00 00:00:00
lastvisitDate
datetime
No
0000-00-00 00:00:00
activation
varchar(100)
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
id
name
username
email
password
usertype
block
sendEmail
gid
registerDate
lastvisitDate
activation
params
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
0
id
id_2
UNIQUE
0
id
name_2
UNIQUE
0
name
username_3
UNIQUE
0
username
email_3
UNIQUE
0
email
password_2
UNIQUE
0
password
usertype_3
UNIQUE
0
usertype
block_2
UNIQUE
0
block
gid_2
UNIQUE
0
gid
registerDate_2
UNIQUE
0
registerDate
lastvisitDate_2
UNIQUE
0
lastvisitDate
activation_2
UNIQUE
0
activation
registerDate_3
UNIQUE
0
registerDate
password_5
UNIQUE
0
password
lastvisitDate_4
UNIQUE
0
lastvisitDate
id_4
UNIQUE
0
id
gid_4
UNIQUE
0
gid
email_6
UNIQUE
0
email
block_4
UNIQUE
0
block
name_6
UNIQUE
0
name
usertype_7
UNIQUE
0
usertype
activation_6
UNIQUE
0
activation
sendEmail_2
UNIQUE
None
sendEmail
sendEmail_3
UNIQUE
None
sendEmail
usertype
INDEX
None
usertype
idx_name
INDEX
None
name
gid_block
INDEX
None
gid
block
username
INDEX
None
username
email
INDEX
None
email
id
INDEX
None
id
name
INDEX
None
name
username_2
INDEX
None
username
email_2
INDEX
None
email
password
INDEX
None
password
usertype_2
INDEX
None
usertype
block
INDEX
None
block
sendEmail
INDEX
None
sendEmail
gid
INDEX
None
gid
registerDate
INDEX
None
registerDate
lastvisitDate
INDEX
None
lastvisitDate
activation
INDEX
None
activation
lastvisitDate_3
INDEX
None
lastvisitDate
password_4
INDEX
None
password
username_5
INDEX
None
username
usertype_6
INDEX
None
usertype
id_3
INDEX
None
id
name_5
INDEX
None
name
gid_3
INDEX
None
gid
sendEmail_4
INDEX
None
sendEmail
block_3
INDEX
None
block
email_5
INDEX
None
email
activation_4
INDEX
None
activation
name_3
FULLTEXT
None
name
username_4
FULLTEXT
None
username
email_4
FULLTEXT
None
email
password_3
FULLTEXT
None
password
usertype_4
FULLTEXT
None
usertype
activation_3
FULLTEXT
None
activation
params
FULLTEXT
None
params
usertype_5
FULLTEXT
None
usertype
name_4
FULLTEXT
None
name
params_2
FULLTEXT
None
params
activation_5
FULLTEXT
None
activation
password_6
FULLTEXT
None
password
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 23, 2017 at 12:35 AM
Last update
Mar 31, 2018 at 07:29 AM
Last check
Mar 15, 2024 at 02:29 AM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `bak_users` WHERE 1
id
name
username
email
password
usertype
block
sendEmail
gid
registerDate
lastvisitDate
activation
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