Question · SQL and MySQL course · Module 9: Indexes and normalization
CREATE INDEX syntax
Which command correctly creates an index on the tytul column in the ksiazki table?
Answer options
- CREATE INDEX ksiazki ON idx_tytul(tytul);
- ADD INDEX tytul TO ksiazki;
- CREATE INDEX idx_tytul ON ksiazki(tytul);
- INDEX ksiazki(tytul) CREATE;
You can check the correct answer by solving this task in the CodeWorlds game.