Server:
mysql.puroparty.com
Database:
puroparty
Table:
extcal2_config
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Table for configurable parameters
Field
Type
Collation
Attributes
Null
Default
Extra
Action
name
varchar(40)
latin1_swedish_ci
No
value
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
name
value
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
63
name
name_2
UNIQUE
63
name
name_5
UNIQUE
63
name
name_8
UNIQUE
63
name
name_10
UNIQUE
63
name
name_13
UNIQUE
63
name
name_16
UNIQUE
63
name
name_26
UNIQUE
63
name
name_29
UNIQUE
63
name
name_32
UNIQUE
63
name
name_36
UNIQUE
63
name
name
INDEX
None
name
value
INDEX
None
value
value_3
INDEX
None
value
name_4
INDEX
None
name
name_7
INDEX
None
name
value_5
INDEX
None
value
name_11
INDEX
None
name
value_8
INDEX
None
value
value_9
INDEX
None
value
name_14
INDEX
None
name
name_15
INDEX
None
name
value_10
INDEX
None
value
value_12
INDEX
None
value
value_15
INDEX
None
value
name_21
INDEX
None
name
value_18
INDEX
None
value
name_23
INDEX
None
name
name_24
INDEX
None
name
value_20
INDEX
None
value
name_27
INDEX
None
name
value_22
INDEX
None
value
value_24
INDEX
None
value
name_31
INDEX
None
name
value_26
INDEX
None
value
name_34
INDEX
None
name
name_3
FULLTEXT
None
name
value_2
FULLTEXT
None
value
value_4
FULLTEXT
None
value
name_6
FULLTEXT
None
name
name_9
FULLTEXT
None
name
value_6
FULLTEXT
None
value
value_7
FULLTEXT
None
value
name_12
FULLTEXT
None
name
name_17
FULLTEXT
None
name
value_11
FULLTEXT
None
value
name_18
FULLTEXT
None
name
name_19
FULLTEXT
None
name
value_13
FULLTEXT
None
value
value_14
FULLTEXT
None
value
name_20
FULLTEXT
None
name
value_16
FULLTEXT
None
value
value_17
FULLTEXT
None
value
name_22
FULLTEXT
None
name
value_19
FULLTEXT
None
value
name_25
FULLTEXT
None
name
value_21
FULLTEXT
None
value
name_28
FULLTEXT
None
name
name_30
FULLTEXT
None
name
value_23
FULLTEXT
None
value
value_25
FULLTEXT
None
value
name_33
FULLTEXT
None
name
value_27
FULLTEXT
None
value
name_35
FULLTEXT
None
name
Create an index on
columns
Space usage:
Type
Usage
Data
1,708
Bytes
Index
3,072
Bytes
Total
4,780
Bytes
Row Statistic:
Statements
Value
Format
dynamic
Collation
latin1_swedish_ci
Rows
63
Row length ø
27
Row size ø
76 Bytes
Creation
Jun 20, 2018 at 09:38 PM
Last update
Jun 20, 2018 at 09:38 PM
Run SQL query/queries on database puroparty
Fields:
ALTER TABLE `extcal2_config` ADD INDEX(`value`)
name
value
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