How to build an index in mysql?

[turbohost]

Hi,

I was wondering if there are ready-to-use scripts available to make an index in a mysql database? I've got a table with a few columns (artist, title, body, ... are a few of them) and I want to build an index from these columns. In fact, the question is 'how do I build an index from these columns'? :->

Turbohost

[Chroder]

[phpmyadmin.net...]

phpMyAdmin is your one-stop for managing your mysql database(s). Just download it and edit the config.php with your database username/password and your pretty much set :)

You can just open up your table and edit the fields to be an index.

[lorax]

Index as in providing a quick way to find data within your table or do you mean index as in a way to a tool that allows you to add/edit/delete data?

[turbohost]

Index as in a way providing quick access to data ...

[killroy]

run mysql.exe

ALTER TABLE tablename ADD INDEX indexname(inhdexcolumnname);

Done :)

SN

[lorax]

Ah, if it's a one time thing and you have shell access on the webserver then you could do as killroy suggests. But if you don't have that access or would like to have a more visual way of working with you db then I suggest you install (and secure) PHPMyAdmin as Chroder suggests.