Home > MySQL > How to Quickly Add Multiple Indexes to a MySQL Table

How to Quickly Add Multiple Indexes to a MySQL Table

February 10th, 2009 Masao Leave a comment Go to comments

Instead of:


ALTER TABLE my_table ADD KEY `key1` (`apple`);
ALTER TABLE my_table ADD KEY `key2` (`banana`);

do this:


ALTER TABLE my_table
ADD KEY `key1` (`apple`),
ADD KEY `key2` (`banana`);

Categories: MySQL Tags:
  1. No comments yet.
  1. No trackbacks yet.