Tag: SQL ForDB

MySQL Query: ALTER TABLE `MyLabDB`.`testusers` DROP INDEX `username` , ADD UNIQUE `username` ( `username` ) COMMENT ‘Avoid duplicate entries for username’; phpMyAdmin GUI:   After setting the Unique Index for the field, whenever a duplicate entry is attempted for insertion, mySQL will result in “#1062” error as shown below: #1062 – Duplicate entry ‘user9’ for key ‘username’ < p>

MySQL CREATE TRIGGER: CREATE TRIGGER `validate_email_insert` BEFORE INSERT ON `testusers` FOR EACH ROW BEGIN     IF NEW.`email` NOT LIKE ‘%_@%_.__%’ THEN         SIGNAL SQLSTATE VALUE ‘45000’         SET MESSAGE_TEXT = ‘[table:person] – NEW.`email` column is not valid’;     END IF; END;   Error SQL query: CREATE TRIGGER `validate_email_insert` BEFORE INSERT ON `testusers` FOR EACH ROW BEGIN IF NEW.`email` NOT LIKE ‘%_@%_.__%’ THEN SIGNAL SQLSTATE VALUE ‘45000’ SET MESSAGE_TEXT = ‘[table:person] – NEW.`email` column is not valid’; MySQL said: #1064 – You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the […]