Question

How to add index to a table in SQL

Answer 1

ALTER TABLE workers ADD INDEX(URL)

 

70+ SQL courses for beginners and professionals

Answer 2

CREATE INDEX URL
ON workers (URL)

 

70+ SQL courses for beginners and professionals

Answer 3

ALTER TABLE workers ADD UNIQUE(URL)

 

70+ SQL courses for beginners and professionals

Answer 4

CREATE UNIQUE INDEX URL
ON workers (URL)

 

70+ SQL courses for beginners and professionals

Answer 5

CREATE UNIQUE INDEX IDX_URL
ON workers (URL)

 

70+ SQL courses for beginners and professionals