To create a MySQL index using SQL,the correct SQL statement is:
A)ALTER TABLE {TableName} ADD INDEX {IndexName}.
B)ALTER TABLE {TableName} INSERT INDEX {IndexName}.
C)CREATE INDEX {IndexName} ON TABLE {TableName}.
D)A or C
E)B or C

Question

Quizplus · Accepted Answer

The Answer of To create a MySQL index using SQL,the correct SQL statement is:
A)ALTER TABLE {TableName} ADD INDEX {IndexName}.
B)ALTER TABLE {TableName} INSERT INDEX {IndexName}.
C)CREATE INDEX {IndexName} ON TABLE {TableName}.
D)A or C
E)B or C

To Create a MySQL Index Using SQL,the Correct SQL Statement