Sunday 29 April 2012

MYSQL Database Command


  1. Delete empty or null record:
    • DELETE FROM `table name` WHERE Column_name is null;
  2. Two column unique key:
    1. ALTER TABLE MyTableADD UNIQUE KEY `my_unique_key` (`group_id`, `user_id`)

No comments:

Post a Comment