This is just a simple quick reference for normal mysql routines that I forget from time to time and have to lookup. Indexes Adding a “normal” index via CREATE INDEX mysql> CREATE INDEX [index_name] ON tablename (index_columns); Example mysql> CREATE INDEX fname_lname_age ON people (firstname,lastname,age); Adding a unique index via CREATE INDEX mysql> CREATE UNIQUE [...]

Tags: ,