Skip to main content

Timeline for MySQL: Create index If not exists

Current License: CC BY-SA 4.0

8 events
when toggle format what by license comment
Jan 10, 2023 at 15:15 comment added dolmen SELECT IF(...) INTO @a; can be simplified as SET @a = IF(...);.
Jan 10, 2023 at 15:14 comment added dolmen @user238855 This is unfortunately MySQL. The query optimizer doesn't seem to be that smart about handling EXISTS.
Oct 6, 2021 at 15:36 comment added user238855 just a note, you do not need to use distinct when using an exists clause. the exist construct will exit on the first match. adding the distinct is adding the unneeded overhead of an implicit GROUP BY.
Apr 28, 2021 at 14:46 history edited Mithun B CC BY-SA 4.0
fixed grammer
Sep 4, 2019 at 6:05 history edited Paul White CC BY-SA 4.0
Incorporated comments
S Apr 11, 2014 at 10:03 review Late answers
Apr 11, 2014 at 12:21
S Apr 11, 2014 at 10:03 review First posts
Apr 11, 2014 at 12:23
Apr 11, 2014 at 9:45 history answered Mithun B CC BY-SA 3.0