How to add Btree or hash index to a table in mysql? [closed]

Question

I have two tables and two queries on those tables. I am using SQL workbench to query these tables. Can someone tell me the syntax of adding BTREE or HASH index to these tables?

Answer 1

CREATE INDEX supports USING BTREE or USING HASH on the end.

http://dev.mysql.com/doc/refman/5.0/en/create-index.html