Answers for "how to add a index to live table mysql"

SQL
2

how to add a index to live table mysql

ALTER TABLE `my_table`  
ADD INDEX `indexname` (`created_at`)
,LOCK=NONE; #add this line to query for live stuff
Posted by: Guest on April-12-2022

Code answers related to "how to add a index to live table mysql"

Code answers related to "SQL"

Browse Popular Code Answers by Language