Add an index to the field referredid in the table user.

[DaQuixlet]

How do I go about doing this? I do NOT have to PHP MY Admin - so please help!

Add an index to the field referredid in the table user.

[Dark_Wizard]

Today at 06:11 PM DaQuixlet said this in Post #1 (https://vborg.vbsupport.ru/showthread.php?postid=425537#post425537)
How do I go about doing this? I do NOT have to PHP MY Admin - so please help!

Add an index to the field referredid in the table user.


No phpMyAdmin? You would need a script then...unless you have telnet/SSH access.

[DaQuixlet]

Come on man - guide me through it...

[Dark_Wizard]

Do you have telnet/SSH access? Or should I create a small script?

[Dark_Wizard]

Here...

ALTER TABLE user ADD INDEX index_name (index_col_name)

[g-force2k2]

try running this query don't know if it works though...

ALTER TABLE user ADD INDEX (referredid)

regards,
g-force2k2

[DaQuixlet]

How do you run a query without PHPMyadmin?

[SmEdD]

Get firefly's query hack or get vB3.