Server:
mysql.puroparty.com
Database:
puroparty
Table:
vids
An index has been added on title (Query took 0.0058 sec)
SQL-query:
ALTER
TABLE
`vids`
ADD
INDEX
(
`title`
)
[
Edit
] [
Create PHP Code
]
Structure
Browse
SQL
Search
Insert
Export
Operations
Empty
Drop
Field
Type
Collation
Attributes
Null
Default
Extra
Action
id
int(4)
No
auto_increment
artist
varchar(50)
latin1_swedish_ci
No
title
varchar(50)
latin1_swedish_ci
No
link
varchar(200)
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
id
artist
title
link
Indexes:
Keyname
Type
Cardinality
Action
Field
PRIMARY
PRIMARY
1
id
id_2
UNIQUE
1
id
artist_2
UNIQUE
1
artist
title_2
UNIQUE
1
title
link_2
UNIQUE
1
link
link_4
UNIQUE
1
link
artist_4
UNIQUE
1
artist
id_4
UNIQUE
1
id
title_5
UNIQUE
1
title
link_8
UNIQUE
1
link
id_6
UNIQUE
1
id
artist_8
UNIQUE
1
artist
title_9
UNIQUE
1
title
link_11
UNIQUE
1
link
artist_11
UNIQUE
1
artist
id_8
UNIQUE
1
id
id_10
UNIQUE
1
id
artist_14
UNIQUE
1
artist
title_13
UNIQUE
1
title
link_14
UNIQUE
1
link
title_15
UNIQUE
1
title
link_17
UNIQUE
1
link
link_18
UNIQUE
1
link
id
INDEX
None
id
artist
INDEX
None
artist
title
INDEX
None
title
link
INDEX
None
link
id_3
INDEX
None
id
artist_5
INDEX
None
artist
link_6
INDEX
None
link
title_6
INDEX
None
title
id_5
INDEX
None
id
link_7
INDEX
None
link
artist_7
INDEX
None
artist
title_8
INDEX
None
title
link_10
INDEX
None
link
artist_10
INDEX
None
artist
id_7
INDEX
None
id
title_11
INDEX
None
title
id_9
INDEX
None
id
artist_13
INDEX
None
artist
title_12
INDEX
None
title
link_13
INDEX
None
link
link_16
INDEX
None
link
artist_16
INDEX
None
artist
id_11
INDEX
None
id
title_16
INDEX
None
title
artist_3
FULLTEXT
None
artist
title_3
FULLTEXT
None
title
link_3
FULLTEXT
None
link
title_4
FULLTEXT
None
title
link_5
FULLTEXT
None
link
artist_6
FULLTEXT
None
artist
link_9
FULLTEXT
None
link
title_7
FULLTEXT
None
title
artist_9
FULLTEXT
None
artist
link_12
FULLTEXT
None
link
artist_12
FULLTEXT
None
artist
title_10
FULLTEXT
None
title
artist_15
FULLTEXT
None
artist
title_14
FULLTEXT
None
title
link_15
FULLTEXT
None
link
artist_17
FULLTEXT
None
artist
Create an index on
columns
Space usage:
Type
Usage
Data
80
Bytes
Index
67,584
Bytes
Total
67,664
Bytes
Row Statistic:
Statements
Value
Format
dynamic
Collation
latin1_swedish_ci
Rows
1
Row length ø
80
Row size ø
67,664 Bytes
Next Autoindex
1,002
Creation
Mar 29, 2024 at 06:22 AM
Last update
Mar 29, 2024 at 06:22 AM
Run SQL query/queries on database puroparty
Fields:
SELECT * FROM `vids` WHERE 1
id
artist
title
link
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