Sql pls help me?

Question

Suppose I have table Emp which contains following column: EmpNo, EmpName, EmpAdd.
Now, the question is write an SQL Query to add an index on the EmpName in the Emp table...
Note: This is not homework question...

Answer 1

The exact syntax depends on what database you've got. There are lots of databases that use SQL as their access language... and lots of versions of those databases.

Here's one way (for Microsoft SQL Server)... it may work for your database:
http://www.1keydata.com/sql/sql-create-index.html

HTH

Answer 2

Guess the EmpNo will be the primary key (unique). To add a secondary index:

CREATE INDEX [index-name] ON EMP (EMPNAME)

Use whatever name you like for [index-name]

Answer 3

Cheat! Use phpmyadmin!

It's actually a really great learning tool, because it will show you the full query you need.

I *think* the query you want is
ALTER TABLE Emp ADD INDEX(EmpName);

Answer 4

there is not any sq. utility, there are databases helping sq. (greater or much less), there are editors that assist you write sq., which one did you prefer? MySQL is a unfastened DB helping sq.. Eclipse is one (of many) editors assisting you to jot down sq. statements... For acquire places use Google...

Answer 5

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