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)Both A and C are correct

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)Both A and C are correct

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