Server:
mysql.puroparty.com
Database:
puroparty
Table:
bd_world_regions
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Field
Type
Collation
Attributes
Null
Default
Extra
Action
rID
int(4)
No
auto_increment
rCountry
int(3)
No
0
rName
varchar(255)
latin1_swedish_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
rID
rCountry
rName
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
0
rID
rID_2
UNIQUE
0
rID
rCountry_2
UNIQUE
0
rCountry
rName_2
UNIQUE
0
rName
rName_4
UNIQUE
0
rName
rCountry_3
UNIQUE
0
rCountry
rID_4
UNIQUE
0
rID
rID_5
UNIQUE
0
rID
rName_7
UNIQUE
0
rName
rCountry_6
UNIQUE
0
rCountry
rID_8
UNIQUE
0
rID
rCountry_8
UNIQUE
0
rCountry
rName_11
UNIQUE
0
rName
rID_9
UNIQUE
0
rID
rName_13
UNIQUE
0
rName
rCountry_9
UNIQUE
0
rCountry
rName_18
UNIQUE
0
rName
rID_11
UNIQUE
0
rID
rID_13
UNIQUE
0
rID
rCountry_12
UNIQUE
0
rCountry
rName_21
UNIQUE
0
rName
rID_16
UNIQUE
0
rID
rCountry_14
UNIQUE
0
rCountry
rName_23
UNIQUE
0
rName
rID_17
UNIQUE
0
rID
rName_25
UNIQUE
0
rName
rName_27
UNIQUE
0
rName
rID_19
UNIQUE
0
rID
rCountry_16
UNIQUE
0
rCountry
rID
INDEX
None
rID
rCountry
INDEX
None
rCountry
rName
INDEX
None
rName
rID_3
INDEX
None
rID
rName_6
INDEX
None
rName
rCountry_4
INDEX
None
rCountry
rID_6
INDEX
None
rID
rCountry_5
INDEX
None
rCountry
rName_9
INDEX
None
rName
rID_7
INDEX
None
rID
rCountry_7
INDEX
None
rCountry
rName_10
INDEX
None
rName
rName_15
INDEX
None
rName
rID_10
INDEX
None
rID
rCountry_10
INDEX
None
rCountry
rName_16
INDEX
None
rName
rCountry_11
INDEX
None
rCountry
rID_12
INDEX
None
rID
rID_14
INDEX
None
rID
rName_20
INDEX
None
rName
rID_15
INDEX
None
rID
rCountry_13
INDEX
None
rCountry
rName_22
INDEX
None
rName
rCountry_15
INDEX
None
rCountry
rID_18
INDEX
None
rID
rName_28
INDEX
None
rName
rName_3
FULLTEXT
None
rName
rName_5
FULLTEXT
None
rName
rName_8
FULLTEXT
None
rName
rName_12
FULLTEXT
None
rName
rName_14
FULLTEXT
None
rName
rName_17
FULLTEXT
None
rName
rName_19
FULLTEXT
None
rName
rName_24
FULLTEXT
None
rName
rName_26
FULLTEXT
None
rName
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
Apr 24, 2024 at 06:54 PM
Last update
Apr 24, 2024 at 06:54 PM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `bd_world_regions` WHERE 1
rID
rCountry
rName
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