Questions of the day (MySQL)

Q. Write SQL query for creating index on a column in a table.

3 Likes

@kaushal-ta-ds
CREATE INDEX index_name
ON table_name (column_name);

2 Likes

@rrnayak2609
Correct :100:
Well done :+1:

2 Likes

CREATE INDEX index_name ON table_name(column_1, column_2, …., columnN);

1 Like

@mashettyomkar123
Correct :100::relaxed: